I have an lnkItemState table and want to get the number of records in
in that have each value of stateId.
if lnkItemState, and lkupState contained the following:
lnkItemState

I have 2 queries one that sorts and sums values by date(DayQuery), and
another that uses the 1st querie and then sums by area(AreaQuery). It works
properally expect when the date has 2 enteries for one area. The Sum is
always double the value.

I was provided a table (XXXXZipCodeSvc) from another party that lists zip
range low and zip range high and a code for each range.  
example
zip range low    zip range high    code

Two table exist, there are some records in both tables that are the same, but
both tables hold other characteristics relating to those records.
e.g both tables hold a Transaction Code Field, I need to exclude the
Overlapping records from Table A and return the remaining records ...

I'm trying to update a column in my data which will add a name based on what
weight bands it falls into.  
I have one table which contains three columns: weight start and a weight end
value (both as long integers) and a name for each weight band (eg Name of

I have a table called 07DATA which has two fields in it:  DOLLARSPAID and
DIRECTION.  Dollarspaid is clearly a currency field which has multiple dollar
values.  Direction is a field which contains either an "I" or an "O".  
What I'm trying to do is to create a query with two ...

My table name is trade - it has 5,000,000 records. I would like all fields in
the table to be displayed in the qury result.
For each Date and c=Customer, I need to sum Qty.
I think this is easy but cannot get it to work.

Hi
I have 3 tables as follows
*tbl_employees*
empID

I'm trying to match up data between two tables -
Table 1: Last name, First name, Address, City, State, Zip, Date of Birth  
(approx 45,000 individuals)
Table 2: Last name, First name, (Updated) Address, City, State, Zip (approx

I've read almost all the msg for the above, but I haven't found a solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box with

My table contains a text field called "Company_Name".
As the name idicates it holds a text value of a name however, it contains
names that may be the same company written a different way.
Example:

Dear Access gurus,
We have an Access database that contains tables that get their data from
another financial system.  We are creating a query which needs to link two
tables together.  However, although they contain some similar information,

What I am looking to do is create a running sum of the [Share Total]
for each [SVP] by Date.
Disregard the many commission columns, they will be irrelevant to the
running sum.

When I follow the instructions for setting up new queries, much like the old
versions. The syntax simply forces a blank sheet and not a list of what is
requested in the criteria! Help?

I have a form that shows employee info which when opened the user has to
input the employee number to view his/her info. I would like to have a
message appear if the associate is not in the database....Something like
"Please add associate to dtabase". Is this possible? Thanks