Unmatched Query

[Guest]

I have two tables that I linked into an Access database. The first is a
simple table that several people key into. When we receive a ledger from a
store, someone takes that ledger and logs it into this table. They key the
store #, district #, what type of ledger it it, date received, etc. The
second table is a list of all of the stores that we have open. It includes
the store #, district #, address, phone #, etc. I need to run a query that
tells me all of the open store that are not turning in any kind of ledger and
then subsequent queries that tell me which open stores are not turning in
every kind of ledger (each store should have 3 types every month). I tried
to run an unmatched query, but it gives me all of the open stores in my
results I think because the whole record does not match or something. Each
store can be in the log table more than once because they have multiple types
of ledgers and should be in there every month also. I am not sure how to
pull this data out. Can anyone help me or give me any kind of advice?
Thanks so much!

 

[Arvin Meyer [MVP]]

There is an unmatched data query wizard that will do it for you. Just click
on a new query and choose the Unmatched wizard.

 

[Guest]

Yes, I have tried this, as I mentioned in my first question. It is giving me
all of the open stores as my query results. The results will have stores in
them that have turned in ledgers, so that query will not work. Does anyone
else have any more ideas? Thanks!

 

[Arvin Meyer [MVP]]

Use that as a start then, and add whichever criteria will limit the
resultset even more. Since the are in there every month, perhaps adding a
date criteria like: >=Date()-30 will only look at data for the last
30 days.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com