List dates that are absent from a list

[rbtm2006]

I have a database that is used every day. I want a query that will list which days are not in the database. We have to delete the raw data and re-import the corrected / verified data. We do make mistakes, so I want a query that will help us ensure all dates are present.

Example.

1/1/12
1/2/12
1/3/12
1/4/12
1/6/12
1/7/12
1/8/12
1/10/12

I want a query that will return 1/5 and 1/9 as missing dates...

any help will be appreciated!

 

[pbaldy]

Two methods come to mind. First is using the unmatched query wizard against a table containing all dates. Second is a function that uses a For/Next loop to step through a given date range, and compares each to the table (DCount or recordset) to see if there's a record for that date. Record each date not found.