I have built a good crosstab query that dispays sales by customer by
quarter.  Lets call it "History/Forecast". Basically is comes up with 200
records of:
Customer Name   Q1sales   Q2sales  Q3fcst  Q4fcst

I am running the following query sql between two Access files that are not
linked together. The records returned are correct. M_Pro has 10,750 records
and M_Lee has 4,357 records. Each has an index named ZLAF comprised of Zip,
LastName,Address1, and FirstName fields with Unique ...

This is probably easier than I'm making it, but I can't seem to figure it out.
I have a table that was imported from a report text file. In the first
column is a control number that I need to use. The problem is that the
control number only appears on the the first record of the ...

basically i have a table consisting of records that contain a date, location,
contract #, and a few more fields containing initials (initials could appear
more than once).
I just want a query that will display all the records in which a certain set

I am trying to build criteria in order to filter out several things. I want
all inventory items that have been used since 1/1/2002 or have a "y-t-d"
(year-to-date) sale or have an "on hand" quantity. If they qualify for any of
these I want it in the query.

I have a table with among others these fields.
Category          Names
PC
Portable

I have two tables - Master & Import.
They both have the same fields and structure.
I would like to update the Master table with the information within the
Import table.

I have several tables linked to Excel spreadsheets.  Each spreadsheet has the
same data fields:
Organization
Date

What is a union query?  When should it be used and when should it not be used?
Thanks in advance for the help.

The table looks as follows: (table  - see further down)
ID - several rows have the same ID
Species - each of those rows with a specific ID have diff. species, making a
combination of ID and Species a unique ID for each row.

I really need some help here.
I have a table "products" and a table called "reports".  Every record in
"reports" can have up to 3 products listed.
Now here is where I think it gets tricky. I am using a form "ReportFiles" to

I have a user who has a single data table that tracks observations.
The fields are:
CF - what is being observed
OD - Observation Date

I have an append query that I run daily and want to append only records with
different  OrderID.
------------------------------------------------------------------------
INSERT INTO tblConfirmSchedule ( OrderID, JobCode, JobDate, Status, [Home#],

Hi,
I recently asked how you can calculate the number of days between 2 dates
without including weekends (Sat and Sun) in a query.
Someone came back and offered the following code and said i should call this

For my report I need to list the most recent item per group. I have the query
listing machine, projects machine is used for, date for the project and some
details for each project.
To simplify say I have the following fields: machine, project, date,