Please assist,
Training Table
LName, FName Training class, Training status
In some cases there will 2 recs per user

I have 3 tables (Customers, Contacts, Products) whose relationship is one to
many.
If I want to use query based on all three tables, it returns duplicate rows.
eg If I have one customer with two contacts and 3 products, the query

I have a make-table query that will not delete the existing table.  Instead
of asking if I want to delete existing table, it just tells me it cannot run
the query because the table already exists.  I have never had this happen
before.  Anyone seen this?

I have a search form, and the user is able to search for students who
haven't taken a class for a certain major.
Students is the main table, then I have a Students_Classes Table, and
another Students_majors table.

Every time I try to run a particular query, I get a pop-up
message that says "Query is too complex" and it doesn't do
anything.  I've had relatively simple calculations just
adding four columns together, and I still get the same

I am trying to create a report on projects. Each report number has update
notes . I would like to only include the note with the newest date with any
given project number. The report is generated from a query. I am not sure how
to filter out for just one. note. The way the report ...

I have a query that includes a field name [last name]. I want to only inlcude
last name3s beginning with A-J. Is there a way to put this in a filter. I'm
sorry I'm brand new at this and I'm just kind of stumbling around. Thanks.
Mel

I am trying to run a report from a crosstab query and keep coming up
with the error:  The Microsoft Jet database engine does not recognize "
as a valid field name or expression
Here is the SQL for my query

Been struggling with this...
I have an appointment book database - tbls: Employees, Clients,
Appointments.  When a client calls, the office needs to be able to see the
next available appointment.  I have no problem showing what's already

I ran a query with Table 1 matching it on Table 2 .  
I found a lot of unmatched data.
How can I delete the data from Table 1 without doing it manually?

Is there any way to use a parameter query that allows the user to choose to
view the results for either one specific criteria or view them all?

I have 3 tables.
In the MTD table there is a field called 'newgrade' which is currently
blank.
I want to update this field with a value from the MM Update table,

I used the expression builder to multiply two fields in a report:
= [tblMasterList]![Qty] * [tblMasterList]![Price]
When I run this I get a Dialog Box: Enter Parameter Value. If I enter a
parameter value, I get a #Error on every line where the answer should be.

I have 10 retail stores that i am over. I have made a mdb. to trak transfers
from store to store.
I need a way to compare [Store] to [Store To/From] if Qty Matches
Example of transfer in

I have 12 fields -- one for each month of the year that have dollar figures
in them.  I want to filter out all the records that have zeros ACROSS THE
BOARD.  Currently, I have <>0 in SAME criteria line of each field but it
seems to filter out the records that just have zeros in ...