I have a query that is based on a table called TARGETS which returns the
number of targets in the table that are marked as "bad", and then grouped by
user. The code for this query is:
SELECT TARGETS.[User Name], Count(TARGETS.Bad) AS CountOfBad

I have a table orders where I want to select a carrier based on the
delivery_country and pack_weight. To do the latter I have defined a new
table freight_rules with this content:
country    weight    carrier    class

I am designing a database to track training.  I have a query that tell me the
mandatory classes, and I have a table with the classes taken data (date
taken, expires, etc).  What I need is a query that show me the classes taken
that are not mandatory.

Not sure how to do this but I have a traning database and I would like to get
a table that is Employee Level vs Class Name.  Where a class is mandatory
would be a true condition.  I have a list of levels in one table, and in
another table two columns (level and class number)

I’m trying to make a report that displays the results of multiple crosstab
queries.  All of the queries have the same rows and columns; only difference
is the criteria.  The problem I’m having is that in some of the queries some
of the rows don’t have any values, so Access ...

It's been a while since I have worked in Access. But I have run a find
duplicates query and I have totally blanked on how to create a table from
those query results.
If there is another way to do this than I am open to that as well.  What we

Good morning,
I am trying to write a formula in my Select query to extract a piece of data
from a field called "A".  The format of the data (for most records) for field
A is "AAA BBBB 200x".  What I like to extract is the date portion of the

How can i create a parameter query in the query grid to ask for all records
based on the month. example: i want all records for May 2007. any ideas?

I got a query to calculate the sum of fields:
SELECT SUM(IIf(isnull(GST)=True,0,GST)) AS TotalGST
FROM tblProject
WHERE ProjectNumber=[ProjectNum];

I have a query like this: Name: Nz([S_Genus_Subgenus];[Genus])
and in SQLwindow: INSERT INTO Mytable ( ID,  Name)
SELECT Diptera.ID, Nz([S_Genus_Subgenus], [Genus]) AS Name FROM Diptera;
The table Mytable exists. This worked a few months ago, but now I get a

Greetings All,
I have a query with these 2 expressions:
Expr2: IIf([Pregnant?]="Yes","1","0")
Expr3: (IIf([IVDrugUser?]=True,"1","0"))

I am a new Access user and am having trouble getting my query to calculate
the correct sum when drawing from two databases. The situation is:
Tables: I have one table that contains information about circulation
(mailing list codes, circulation counts for each mailing list code, ...

I am trying to create queries to sort church membership data according to any
number of ministry groups (out of a possible 56) they volunteer for. My goal
is to create a report for each of the Ministry's with name and contact
information. I have some questions with corresponding ...

Can anyone explain to me the logic behind criteria in queries?  I
understand how to create them and the different words to use, but I
don't understand how Access actually uses it.  To be even more
specific lets say I have one line of criteria that consists of

Hi,
I am having trouble returning the top values in a GROUP BY or TOTALS query.  
I would like to GROUP BY an attribute (Accounts) and return the top 5 values
(Deposits) per account holder.