EmployeeID & Missing Numbers query

R

Randy

I have a table "Gaps" which is populated with missing sequential numbers
from another table "CompletedCertificates". My "CompletedCertificates"
table has certificate numbers entered from the beginning to the end in two
fields [StartNumber] and [EndNumber], each number is not entered
individually, only the range, I also has a field of [EmployeeID]. I need a
query that will show me the missing [CertNumbers] from table "Gaps" and
include the appropriate [EmployeeID] from the "CompletedCertificates" table.
I can't find any solution...Thanks for any help...Randy
 
P

PC Datasheet

Your tables need to look like:
TblCompletedCertificates
CompletedCertificatesID
EmployeeID
StartNumber
EndNumber

TblGaps
GapsID
CompletedCertificatesID
MissingCertNumber

Create a query based on both tables joined on CompletedCertificatesID.
Include EmployeeID from TblCompletedCertificates and MissingCertNumber. Set
the criteria for EmployeeID appropriate for whatever you are doing and you
will get the MissingCertNumbers for the EmployeeID.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with module 2
Group by date on employeeID 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Update query syntax: SUM and GROUP BY 3
Update query / Operation must use an updateable query error messag 4
AutoNumber Field Not Populating with Append Query 2
query to show where no data in a stated column 0
search missing numbers 4

Top