I have a query that groups failures by audit type. I want it to group only
the top 5 failures for each audit type. (not just the top 5 failures)
Suggestions?
SELECT spdMainQuery.AuditType, spdFailures.Defect, Count(spdFailures.Defect)

I need to list the records in one table (8,000 rows) that are NOT in another
table (40,000 rows).
I tried SELECT ... WHERE NOT IN (SELECT...) but it took forever to run and I
had to cancel the query.

I'm a little lost and hoping someone can show me the light at the end of the
tunnel.
I have 2 table
1- General Info

I have a form that allows me to search my table using a number of key words,
I also included a button where I could take the search results and put them
in a report format for easy printing. Initially the date would not print so I
added this code strCriteria = "[Date Out] Between # ...

I have a table (Table 1) with three columns of the following type:
Example Table1:
Col1 - Text
Col2 - DateTime

How do i get the last dates out of a table in a query
My query looks like this
Station Code and set number    Date off inspection
CNC 18                                  10/11/2005

I have a table that gets updated every week. However, each week, this table
is deleted by a MAKE TABLE query so the number format doesn't hold. So I
created an update query to fix this problem. I want the number format to have
2 decimal places. This works fine, however, there are ...

Hello my database looks like
Name Age
Hello 21
Hi 25

how do I search for an * in a text field? I mean the character * (ASCII42)
rather than a wild card. I've tried 'like chr(42)' in the query parameter but
this returns reocrds that don't have a * in the text field

I'm trying to do something a little funky here and I'm not sure if I'm
approaching it the right way.
I'm running an update query that will contain SocSec numbers for 4
different fields.  Obviously each one needs to be different for each

a problem to do with bidding on a limited number of items.
(simplified form)
table1 contains housetype  and NumAvailable e.g.
type    numAvail

My query will output part numbers for labels in ascending order
Depending on the number of labels
Is it possible to incorporate a flag (***) when the part number changes
i.e.

I need to be able to INSERT INTO with dynamic sql into a table with an
autonumber key field.
I have read a number of posts from 1997 to 2001 on Google Groups with
this exact question and the answer being given to just ignore the

In the QBE Grid, with Like "INT'L" in Criteria, my Query works fine.  It
fails when I try to create a dynamic Query with this VBA:
' Build criteria string for Broker
For Each varItem In Me.lstBroker.ItemsSelected

Using Access 2003
I have Query that has Current Date, PtsOnThpy (num), PtsOnOdrsts (num),
Appropriate Thpy Percent which is an expression "PtsOnOdrsts/PtsOnThpy"
What I need from this query is