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 ?
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 ?
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
Code: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#));
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I found the solution , Just i add is null in criteria and now i shows the data what i need , Thanks for your support