good morning,
i have a database which has the following columns on a table:
Unit   |  Associate | Date | Data 1 | Data 2 |
I want to have a query that says the following:

Here is my problem. I got some help before, but it isn't working.
I have a database with kids' times for each course that we run. Each
year they may run a course several times. The information I have in
the file on them is Name, Grade, Course, RunTime, RunYear, Male/

To first explain, we have a server that contains 5.5 million records of
financial accounts (I work for a debt collection agency). Some people may
have records with multiple debts with different banks (or whatever). Some of
these duplicates will contain phone numbers and what I ...

I have a table with Product_ID and Part_Number
I want to find which (if any) Part_Number's have more then 1
Product_ID assigned.
I was thinking I could manage this with a relatively simple query but

I am trying to create a query that displays data from a combo box and
autofill in a subform (I hope that makes sense) But when I set up the query
it shows no data. I was told to link the two tables in the query design. I
did and it is now pulling the correct data but the field ...

Is it possible to create a field with autonumber type when I'm using a SQL
string inside VB to do a make-table query?  I'm not sure what the syntax
would have to be.  
For instance, dates require ## and strings require ' ' but does the

consider the standard grading query:  given a numeric grade, dblGrade,
I can do this to return the corresponding letter grade:
IIF(dblGrade>=90,"A",
IIF(dblGrade>=80,"B",

I am trying to create a third calculated field that will add two values:
Referral To Consult: Nz((DateDiff("d",[MO Referral],[C1S])),0) and
Consult To Treat: Nz((DateDiff("d",[C1S],[MO Tx])),0)
I do get values for the above two fields but when I attempt to add them using:

I use an external database (access 2000) with quite a number of tables, in
which the marks of my students are placed.
I want to put these values in specific Excel sheets based on the classes the
students are in. I work with a Pivot Table, drawing the data from the Access

I have a contacts tbl and a donor table with a one to many relationship.
I am trying to select all contacts that have ever given and only return
their phone number. I am retuning multiple data for every contact for every
gift.

I have a table of several water quality parameters collected by a sensor
permanently mounted to a pier.  Occasionally a grain of sand or critter will
temporarily disrupt the sensor.  I need to be able to locate these blips by
comparing each record to the adjacent records and ...

I am trying to create a query that will pull specific information from my
field .. for example I have different schools in my field .. Sunshine
Elementary, Sunshine Middle, Sunshine High .. if I want to do a query to pull
ONLY my Elementary schools .. how do I tell my query that? ...

I have an Access front end to a SQL Server 2005 database using ODBC linked
tables. There appears to be a problem when using the euro symbol in queries.
SELECT *
FROM tbl_Datatable

I am having trouble with a query showing all results.  I have a field in my
query "Paid Date" and under criteria I have put "is Null"  so that I can find
all records that have not been paid.  When I run the query it still shows all
records with and without data in the "Paid Date" ...

We have three client categories for our top clients:  A, B, and C.  About
half of our clients do not have a category and are simply null. They are in a
field called ClientType.  I am trying to do a report on item sales (field
name FullName)  by ClientType.  I am also trying to ...