Running & Setting Up Queries - Page 1066

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
playing w/dates by Ron Hi, I've customers (client_id, customer_name) who have ordered (order_id) items during the year (date_in) and than stopped ordering. I'd like to list the...	December 25th, 2006 09:47 PM by John Vinson	2	75
basic counting problem by Jean-Paul Hi, I know this s basic but I don't know what I am doing wrong My table with fields: datum (=translation for date) and therapist I want to count the records...	December 25th, 2006 01:19 PM by Jean-Paul	2	75
Help with If statement by Antney I don't understand Duane. What control could I use, a combo box and a list box would be too much data for those particular controls. I'll be going off of...	December 24th, 2006 08:53 PM by John Vinson	4	80
need to save this data to either a database (access or oracle) or spreadsheet (excel) by Mohsin Hi there (Greetings) I am constructing some forms on which data will be entered. I need to save this data to either a database (access or oracle) or...	December 24th, 2006 06:08 PM by '69 Camaro	3	66
Query for Days since she was born by Bikini Browser Folks: I am not a programmer so I need some help here... I need a small program written that tells me how many days old my daughter is since she was born....	December 24th, 2006 04:23 PM by Rick Brandt	1	69
Help with If statement by Antney I have a command button that when clicked, it brings up an input box. The user has to put in a date (mm/dd/yyyy). I need an If statement that searches the...	December 24th, 2006 04:20 PM by Antney	4	76
Join query by chun via AccessMonster.com Hello I am having a problem here with the query. This is my table with following fields Fields - GroupNo,Grader,Points GroupNo-Grader-Points 204-Jack-...	December 24th, 2006 01:22 PM by Gary Walter	4	69
what's wrong with my query by cho Hi, SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., .,...	December 24th, 2006 12:56 PM by Ken Snell \(MVP\)	3	82
Errors after table name change by Moe I remaned Customers table to Customers_1 and re-created it from scratch. I later deleted the Customers_1 table. since then I have created so many forms and...	December 24th, 2006 07:56 AM by tina	1	67
Access 2003: How many queries? by Rotata I have a moderately-sized database with over a couple dozen tables. I use this to track employees (hire, fire, transfer and promotions), maintain specific... ( 1 2)	December 24th, 2006 05:28 AM by '69 Camaro	10	119
Slow Query? by Smartin My Query: UPDATE HISTORY_TABLE SET ROLLOFF_DATE = DATE() WHERE SOURCE_SYSTEM = 'TAS' AND HISTORY_TABLE.REC_ID NOT IN (SELECT REC_ID FROM ODCOH_TAS); When I...	December 23rd, 2006 09:05 PM by Smartin	5	66
Using ActiveX Calendar to pupulate dates by MARK I have a simple query that uses the Between and criteria. I have been asked by the users to incorporate a calendar. I tried this without success. Can...	December 23rd, 2006 07:25 PM by Clddleopard	4	101
HOW TO SAVE DATA IN ACCESS & ORACLE TABLE FROM VISUAL BASIC FORM by Mohsin Good Morning to All (Christmas Greetings), indeed many thanks for your prompt response apropos my question. as every body knows that visual basic is...	December 23rd, 2006 05:13 PM by Marshall Barton	1	63
Number of the same contents of cells in a column of a table by a . by Jakob Schog Ich mÃ¶chte in einer Abfrage ermitteln, wieviele Personen in einem Projekt eingesetzt werden, wobei die jeweiligen Personen in mehreren DatensÃ¤tzen mit...	December 23rd, 2006 10:49 AM by Gary Walter	3	50
How to Save Visual Basic Data with Access or Oracle through Data Control or ODBC by Mohsin Hi Every one( Good Day) Any one can help me to save visual Basic Data in Access to make link through Data control or ODBC. when i am trying to save vb data...	December 23rd, 2006 05:33 AM by Mohsin	4	63
IIF Issue in Query by mattc66 via AccessMonster.com If the PercChg is 5% up or down I want it to have a -1 in Expr2 column. This is my formula in the query. Expr2: IIf(=1,0,=) Or = It's not working correct,...	December 22nd, 2006 11:30 PM by mattc66 via AccessMonster.com	3	74
dynamically querying different tables based on a value in a combo box on a form? by Conan Kelly Hello all, Is it possible to set up a query to query different tables each time it is run based on the value in a combo box on a form? I have a Table Names...	December 22nd, 2006 09:22 PM by John Nurick	5	73
Streak - how to calculate by PJ I have a table with game_id, player, result where game_id is a sequential autonumber (game_id 1 happened before 2, etc) and the result is either win, lose or...	December 22nd, 2006 09:13 PM by John Nurick	1	109
Using a year from a text box in a qurey by Paul B New to using access so please be gentle :) Criteria in query Between #1/1/06# And #12/31/06# I Have a form named frmYear with a text box named tbYear How...	December 22nd, 2006 08:42 PM by Paul B	8	69
remove dashes by GGill In my table i have phone column. The data format in this column is look different. For Example: (800)333-4622, 800323-8800 and 8003233800. But in my form...	December 22nd, 2006 07:53 PM by GGill	7	79

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed