Primary Keys are in " "
Database Tables:
department ("deptNum", deptName, deptCity)
employee ("empNum", empName, empCity)

I am trying to create a list of top 100 customers by spending for each
store.
I can successfully create the list of top 100 customers for all stores, but
when I try and group by store, not all stores are represented.

I have a payroll database that daily I have to check if everyone's time
sheet has been submitted.  I would like to automate the query by being
about to supply a range of dates to pivot on.  For example
Select * From TimeSheets

I have two tables.  The first table has program names (Program) as it's first
field.  It stores other program info in it as well.  
In the second table it has the program names again and the second field is
phone #'s (Phone).

Each individual query is fairly simple.  One table has fields for three
possible sales reps, I need to treat them as as one set of fields.
Each query is identical, except for the three fields that refer to Rep1,
Rep2, and Rep3.

Can this be done in Access?
I have query which returns all the results for a criteria.  What I want is
another query which determines the total of the top n results, where n will
be changing number (argument).

Could someone help me with a delete query? I want to build a query that
deletes the data in specific fields I have a table which has a date field
and I want to delete some of the data in some of the other fields in my
table where the date in the record is a specified date. I have ...

I have a parameter query that has worked fine for 2 weeks this morning i went
to run the query and yesterdays data is not there.  If i go to the table
where the data is stored it is there the query just isnt pulling the results.
The parameters are a date range and a product

Hello, Hope you are doing well.
I am somewaht basic in my databases, and am not good with code.  I am
trying to build a query that will pull a bunch of info from one table
(table 1) and one column from another table (table 2).  The items that

My apologies if this has been answered elsewhere - being a complete SQL
newbie I don't know what to look for.
I have a table that looks something like this...
 ID   Type     Qty

I want to print 1,000 A5 vouchers (only one of each record) two too view on
an A4 sheet.
When I guillotine the A4 in half and place the right stack underneath the
left

Ok here's the issue.  In order to find MFG #s with different prices (since we
should always be charged the same price for said product), I had to make two
queries.  The first one to group the products and the second to find
duplicate product numbers with different prices.  ...

I was able to occupy myself for a couple weeks without posting a question
(yay!). But I am back again with a doozie.  Hope someone can give me some
direction.
I have table1 and table2, identical structure.  Each week I get a new Table2

I'm trying to write a routine to 'clean out' various records from their
source tables after I've copied that data to an 'archive' table.  The
application is to manage appointments, and these are appointments which are
now in the past.

I have a query to return only last ten records added, made with wizard:
SELECT TOP 10 Tbl_Sponsors.SponsorID, Tbl_Sponsors.Title,
Tbl_Sponsors.FirstName, Tbl_Sponsors.LastName, Tbl_Sponsors.Ad1,
Tbl_Sponsors.Ad2, Tbl_Sponsors.Ad3, Tbl_Sponsors.Ad4, Tbl_Sponsors.Ad5,