Find missing dates in table.

[shod90]

Dear Gents,
I have a timesheet project done with access and the accountant need to know which specific days the employee didn't create a record .

could it be possible ?

[June7]

This question has been asked often. Here is one similar discussion https://bytes.com/topic/access/answe...ng-dates-query

For a query approach, you would need a dataset of all possible employee/date pairs in order to determine what is missing in the time data. This is called a 'Find Unmatched' query. Access has a query wizard for that.

[shod90]

I already follow up the link you have provided and i reached to a very good result but only remaining one thing.


That's what i received .. But i need to only show the dates which have null value in Dates field .. I mean
6/1/2023
7/1/2023
11/1/2023
and so on.

and this is the sql view

SELECT Dates.TDates, Query2.DatesFROM Dates LEFT JOIN Query2 ON Dates.TDates = Query2.Dates
WHERE (((Dates.TDates) Between #1/1/2023# And #1/31/2023#));

[June7]

Expand the WHERE clause: AND Dates.Dates IS NULL

Your query lacks a space in front of FROM. Must have been just a posting error. The forum tends to combine first two lines of code. I always have to fix.

[shod90]

I found the solution , Just i add is null in criteria and now i shows the data what i need , Thanks for your support