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.
She was born September 26th, 2000.  I am keeping a journal for her to read

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 column, if the date typed in is in the column, of course it will bring up
the data. But if the date is not in the column, I ...

I am having a problem here with the query.
This is my table with following fields
Fields - GroupNo,Grader,Points
GroupNo-Grader-Points

SELECT [AC Jan No].[Jan No], [AC Fan Line].[Date], [AC Fan Line].[Model],
[AC Fan Line].[Lot No], [AC Fan Line].[OQC Function], [AC Fan Line].[OQC
Appearance], [AC Fan Line].[Shift], [AC Fan Line].[Line], [AC Fan
Line].[RoHS Status], [AC Fan Line].[OK Quantity], [AC Fan Line] ...

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 queries without any problem. Today I created a Balance query to calculate
balance on customers.  When I try to open the ...

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);

Good Morning to All (Christmas Greetings),
indeed many thanks for your prompt response apropos my question.
as every body knows that visual basic is Application Bulider.
suppose, i am going to make a simple programme for two Numbers

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 in
Access after making link through data control it is not saving what is

I have a field in my query called Date.  Under criteria I currently have
"Between [Type Start Date] And [Type End Date]"  However, I would like the
End Date to just be calculated based on the Start Date.  For example, if the
Start Date is 1/1/2007, I want the query to calculate ...

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([PercChg]=1,0,[PercChg]>=[PercFactor]) Or [PercChg]<=[PercFactor]
It's not working correct, the rows with -3.55% and 3.51% should be 0. Can

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 table set up that contains all of the table names that
I would like to query.  I have a form set up with a combo box bound to the

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

Ich möchte in einer Abfrage ermitteln, wieviele Personen in einem Projekt
eingesetzt werden, wobei die jeweiligen Personen in mehreren Datensätzen mit
unterschiedlichem Datum vorhanden sind.

I have simple query, which has join of 3 tables.
The database is sql server 2000 to access 2003 by ODBC.
After i change the odbc connect to another database with the same structure
but with diffrent indexes my query becomes read-only.

Ok, I have a picky boss who is asking me to make a query that will show all
spending by payee and also show project spending in same query. Is this even
possible? The estimated number is a number he want to plug in, not a
calculated number.