Query - Filter Duplicates Problem (Easy?)

  • Thread starter Thread starter Nitrogen666
  • Start date Start date
N

Nitrogen666

Hey there,

I am creating a database that monitors which people go in and out of
building.

I am using a table. When someone enters the building, a record i
created with their name and the current date.

Basically, i'm trying to create a query which will list the people'
names that have not entered the building in over a year. The thing is
a lot of the people will have multiple records - e.g. there will be
record for John Smith for when he entered the building two years ago
but there will also be a record for the same John Smith from last week
I'm trying to figure out how to not display any records of John Smit
because he has in fact entered the building within the last year.

I hope i've made it clear enough - thanks for any help you can give
 
One approach would be to first find all the folks you DON'T want to see in
your final answer set. If you queried for all the folks who HAD a table row
within a date range, this sounds like it would tell you who NOT to have in
the final answer.

Then use the original table plus this "not these" query and use the Query
Wizard to help you set up an "unmatched" query (i.e., which of 'these' are
not in 'that'?).
 
Back
Top