Ahmed,
I would first create a table or query with every possible date. You can then use the Find Unmatched query wizard to determine the missing dates.
Duane Hookom MVP
MS Access
----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: ahmedhashim1@gmail.com
> Date: Thu, 27 Dec 2012 05:28:56 +0000
> Subject: [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
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar