EmployeeID & Missing Numbers query

  • Thread starter Thread starter Randy
  • Start date Start date
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
 
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.
 
Back
Top