Query Help

[Guest]

I have two tables that I need to use for this query. The first table is
tblRptsCheck and the 2nd table is tblDailyRptsMatrix - Information is entered
through a form to tblRptsCheck. The information is dated so that we can make
sure that the reports are received that day. I want to be able to run a
query that shows that reports that have not been received for a particular
day.

Any help would be greatly appreciated.

 

[John Spencer]

Is tblDailyRptsMatrix a list of the expected reports?

If so, two queries should be able to give you the list you want.

First query, get all the reports that have been input for the specified
date.

Now use that query and tblDailyRpsMatrix in an unmatched query - use the
query wizard to build this query.

If you need more specific advice, you will need to post some more details on
your table structure.