Find missing records

[Malc]

I recently asked the following:

I have a database which holds timesheet data for a group
of people working on several projects.

There is a Projects table (code, name, etc.), a User table
(id, name, etc.) and a Timesheet table which references
the user id, the project code and the days spent on a
project by a user for a particular week, using Saturday's
date as week ending.

What I would like to do is to query the timesheet to find
if any records are missing, i.e. details were not entered
for a user for a particular week, and print out that users
details for rectification.
-------------------------------------------------
I was told that I would need to post the structure of the
timesheet table to get an accurate answer.
-------------------------------------------------
So, as requested here is the structure of the timesheet
table, hope this is what was wanted.

Field Name Data Type Desc
===============================================
idnum Text Users ID number
week Date/Time week ending the Saturday
projcode Text code of project worked on
location Text UK/EC/nonEC
chargeable Text Yes/No
activity Text type of work done
sun Number quarters of day worked
mon Number
tues Number
wed Number
thur Number
fri Number
sat Number
totdays Number total days for week

The idnum is linked to the ID num in the User table and
the projcode is linked to the projcode in the Projects
table)

I hope this all makes sense and thanks in advance.

Malc

 

[[MVP] S. Clark]

Return to your original post, where we've been discussing this.