Bear with me please, I have a general knowledge about Access but am not a wiz.
I have created an access database for my new company that will import employees' timesheets from excel with associated employee numbers, hours worked, job number worked on, and date worked called "Time-2009". Other tables I have are "JobList" (Job number is the primary key, also includes client and job name), "Employee" (Employee number is primary key, also includes employee name and status).
When I run a querry to list all the time being billed out, everything is the way I want it. Except this: if for some reason an employee billed time to a job number that is not in the "JobList" table, that particular record will not show up in the querry. Obviously, since the primary key does not match what is there, there's nothing to show.
I need to find a way to compare my table with employees' billed time, mainly the job numbers, and the "JobList" table to find any missing entries in the "JobList" table. For instance, in the attached file, job number "115-1" is not in the "JobList" table however it is being billed time in the "Time-2009" table. When you look at the "All Time" querry, that record is not there.