I have a strange behavior with my Access 2003 database in date
calculation in a query.
My query is supposed to give me all the invoices between date X and
date Y from the INVOICE table.

I want to create a query that's NOT equal to 9 or 12, but is not working.
Here is what I have so far:
SELECT [num], [serial], [id]
FROM [DETAIL]

I've a query and I would like to select all lines if the parameters is equal
to 1, over, I would like to list all lines wich the parameters equal to [NUM].
The [NUM] columns contains a value 2, 3 or 4.
I've this fields on my query :

I have 2 tables linked to external 3rd party databases.
StsDate and FTData. Both are performing the query and returning the records
as expected. STS is configured as a select query and prompts for a date, when
entered all transactions for that date are returned.

I am trying to utilize a combo box to allow the user to select an indivudual
from a list which will filter the query and provide a mailing list for just
that sale reps accounts.  I would then like that list email in .xls format.
Here is my code:

Here is my sql string and the message is "No
value given for one or more required parameters"
"INSERT INTO masterdype ( activeyear, dypeid, hospitalid, degrees, served,
dutied ) SELECT qrmasterstatlinked.activeyear, qrmasterstatlinked.dypeid,

I have set up a table in the format shown below.
Date                  Name                Points
11/04/05           Jim                     10
11/04/05           Ed                       6

I have 55 tables that I need to append to 1 master table.  The 55 tables are
created by an outside program that picks random numbers (I can't change this
part of the process).  I do not want to have to change the source table on my
append query 55 times.  How can I use VBA to ...

Ok this is the situation.
I have these tables
tblEmployee
tblEmpDeductions (Employee Deductions)

I have run into a problem in my query.  I am trying to run calculations on
water meters.  I have been able to calculate the information I need on my
forms, by using DLookup, but it's a bit more tricky to do in the query.  
These meters are read everyday, and the calculations ...

I have recently been upgraded to Access 2003 from 97. Now whenever I make a
change to a query in design view and then close the design view of the query
I am not asked if I want to save my changes. Then when I open the query I see
that my changes were not saved. I go back to the ...

I have a table with the following values
Item No
123
123-AI

I have several queries that run off the same date (mmm-yy format).  How can I
enter the date one time instead of several times?
Also, I need to build a query that will take the date mentioned above and
add the previous 11 months of data.  I was able to build the query where the

I like to create a table with SQL with a autoincrement field. But the
autoinc value should not be in a range, but a random value.
With the table designer it is just about setting the property right, but how
can i do this with SQL?TIA<

The data set looks lite this:
A           B             C
1           c             49
1           b             85