flaggkort
asked on
How do I write a query in Access 2007 to display dates missing in sequence
I have a table that gets updated every night when a store runs a report. Sometimes the stores forget and that row of the table will not have that dates information. So I guess I need a formula for example if 2/1/09 -2/21/09 rows are updated but missing 2/5 and 2/8 I need for the report to show me the dates 2/5 and 2/8 as being missing. I know how to put the date range in the criteria but I don't know a formula for checking for missing dates in the sequence.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
flaggkort,
You can also use some pretty simple things to prevent missing values in the first place.
(Like checking for a missing value when you try to enter a new record)
Try this simple, basic example:
JeffCoachman
Access-EEQ-24169649PreventMissin.mdb
You can also use some pretty simple things to prevent missing values in the first place.
(Like checking for a missing value when you try to enter a new record)
Try this simple, basic example:
JeffCoachman
Access-EEQ-24169649PreventMissin.mdb
http://www.devx.com/dbzone/Article/40345/1954
/gustav