[MS_AccessPros] How to find missing dates

 

Hi to all,

I've a database where data entry made in table for Salesman expense recording.

Table structure:
TransID (Auto)
Trans Date (Date Time)
EmpID
ProductID
Area

Data entry is made on date-to-date basis, I need a way to find if any particular date entry is missing in table. Like for e.g Data entry is made for following dates (Date format is DD/MM/YYYY):

03/12/2012
04/12/2012
06/12/2012
07/12/2012
08/12/2012
10/12/2012
12/12/2012
13/12/2012
14/12/2012

In the example given following dates are missing:
05/12/2012
09/12/2012
11/12/2012

How can we trace these missing dates? Any suggestions? Queries/VBA?

I am using Ms.Access 2007.

Thanks and best regards

Ahmed

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___