I keep getting an "Overflow" error message when  I run a Query that asks the
date. I can do every year but 2002.

I have a query to get  inventory item sold total in a period.
i.e. total 5 items from item1 to item5
from 1/1/2004 to 12/31/2004 sold following items
item1  10

I have a birthday field called 'Birthdate', it is formatted as mm/dd/yy.   I
need create a query that asks for just the month....

I have a crosstab query which displays all training dates for all our teams.
I would like to copy this query and have a prompt to enter a team name so a
single team may be viewed at any given time.
I've checked the disscussion board but I dont really understand what I need

Viewing a query will show record number and total records in the record
navigator. Can I show the record numbers in the record itself? I have no
uniqueid to work with. I just need to have a
autonumber/sequential/incrementing column. Help? TIA

I have a front end with tables linked to three back ends.  In the front end
are a number of select queries and several union queries.  One union query
based on two select queries generate 19 columns of data.  In one column
called "lengthID", foreign characters and symbols are ...

I was given permissions to access MSSQL server.  I would like to query data
from MsAccess on that server.  I was trying to link to it via ODBC connection
- I am not sure if this is ithe right approach and what information I need
form the SQL administrator?  I would appreciate ...

I have two databases  (Access 2003) which have same tables. I imported
queries from one database into another database. Most of these queries have
preview error like:
Syntax error (missing operator) in query expression ‘TableA.’.

I am trying to build a query to find multiple times a table has multiples of
if two different fields.  Let me explain further with an example:
We have a table where our Purchase Orders (PO) are tracked and it has the PO
# and a Line # as its primary keys.  In this table we put in ...

few days ago I have posted a message with the same subject. My code was a
bit different from this one and the answer was that I received the err
message "Operation must use an updatable query" because I was using aggregate
function in my subqueries.

I'm trying to get the number of identical values from 2 tables.  The problem
is the query takes a really long time to run.  Is there a way to do this
faster?  This is what I do now:
select t1.f1 from t1 where t1.f1 IN (Select distinct t2.f2 from t2)

Fairly simple (I believe) question here: Several queries of mine need a
default value if the requested value is null. For example:
Location: IIf(IsNull([Office Name]),"Office 560",[Office Name])
Now what I want to do is replace "Unknown" with the value in a table

I am trying to run the following update statement on an Access 2000 database
table:
UPDATE CL
SET SofsbypandR = xx.mysum

I *think* I've seen what I want to ask, but I've tried it and can't get it to
work.  So I figure that I'm remembering wrong or just have the wrong syntax. (My
*usual* problem.)
I have two separate fields of names, usually in the format of LAST, FIRST MI.

Can anyone tell me how to do calculations between different Records
(Rows) in a Query?