Find on;y records without a match

[Homegrownandy]

This is a problem I have asked about before but I think I wasn't approaching it correctly.



Now in access I have a table relating to information on a typical "timesheet". The only concern I have is the "weekending" date field.

Every week we should get information from the engineers to be put into this table. The corresponding date is also stored.

I want a want to see who has not submitted their timesheet.

every member of staff should submit one.

That's the problem......

my idea.. which im having trouble implementing. Would be a combo box where the user can select a date and the query would find all names that do not have a timesheet with this date.


Any help appreciated.

[ranman256]

you want an OUTER join.
make Q1 to pull all persons timesheet for that 1 week.
now make Q2, add in Q1 and the table of all persons, tEmployees.
join the 2 queries on person#.
dbl-click the join
set the property to ALL records from table of persons, SOME records from Q1
bring down the person Name from BOTH queries, Q1.name, tEmployees.Name
under Q1.name, set criteria to NULL
run query.

the null records are what is missing.

[orange]

As ranman says
If you have
a) a list of employees, and
b) a list of employee time sheets for this week

[Homegrownandy]

I even have a diagram haha! I was looking at similar things but didn't have any success. Hopefully I will get some time to day to implement this. Failing that ill update tomorrow.

Thank you for the answers.