im doing something i thought was very simple.  i have 4 fields in my select
query.
the year field which is set to group by, Loan amount set to count, race code
set to Where, ethnicty code to where,    i have the race im selecting in the

I need to write a query that counts number of unique occurences of a
combination of 3 fields in the same table (Inventory):  PC Brand, Operating
System, and Speed.  How do I write this?  I know how to write a count query
for one piece of data - I don't know how to do it for a ...

Ok I am trying to generate a query using 3 other queries. I'm having success
so far except for 1 problem. The "Briquetting Rate Query"  looks fine on its
own, however when I combine it with the other 2 queries into a whole new one,
it seems to OCCASIONALLY duplicate the record ...

How do I set up an autoupdate query (using a form) that will automatically
popuplate a table with data from another table?  Example of the table to
update..
PLTable.Activity Number (Text)

Help! I can not solve this. Must be SQL, as I connect through Jet.
Pmts not fully Applied (such as clients who prepay), must be accounted for.
Database structure:
tblClients:

I have a table (called TABLE A) which looks like this:
WORD                 | onum   | nnum    |
SCHOOL            |  55569  |  99999 |
ENGINEER        |  77888  | 99887  |

I have a table that has six columns: Project Name, Project ID, Address, Legal
Description, Cross-Reference, and Box Number.  I want to create a query where
a person can search for records using any of these fields.  I know i can
create a parameter query for each field, but is ...

If I have a table as follows:
ID         Value
1           2
1           3

How do I turn the following query into a table?  I've gone through the
documentation, tried several potential leads, to no avail?
What is this about? I want to make a table out of all KeywordSets assigned
to a KSGroup whose ID is 5.  Five consists of persons.  A keywordset can be

I have table A with ID and Name as fields, I also have table B where some of
the same records appear.  I would like to create an SQL stsement that would
return only records from table A where they do not appear in both tables.  
Can anyone help????

I am having trouble with an update query executing. The query only runs when
I go to the objects window and double click on the update query "Reserve
Room". Here is what I have done. I created a table with a check box - checked
(Yes) room is available, unchecked (No) the room is ...

Would someone please explain why this does not work!!  I have a table with
different values in it and all I want to do is write a query that tells me
the number of entries between $0 & 100, $101 & 500 and so on.  There is some
basic concept that I grossly misunderstand.

I'm setting up an awards database.  I'll have 30 people and 50 awards.  I
need a querry to select LastName and only pull up the checkboxs that are
checked yes.  For instance, Jon has 6 awards out of the 50 possible.  I only
want to see Jon's name and the 6 that are checked yes ...

I can't figure out how to write a criteria with Access 2003 for this
situation.
I would like my AppendQuery to only pull the data from the record set that
has been modified in the last 10 seconds.

I have the following query:
SELECT Trainee.IDENT, pcAssUnt.ACTDATE
FROM pcAssUnt INNER JOIN Trainee ON pcAssUnt.IDENT = Trainee.IDENT
WHERE (((pcAssUnt.QUALTYPE)="Q"))