OK, so I have the tables built and am importing the spreadsheet as a whole. So could someone give me a little kickstart on how I might go about tblCertifications?
The Import table has the employee ID of each person and a field for each of the 18 pieces of equipment with a date in the field if the employee is licensed.
I was thinking of a query for employee ID if each of the other fields Is Not Null.
Thus I would have 18 querys and append those results to tblCertifications.
However, I can't seem to come up with a way to make it click and there is probably a less messy way then 18 queries. What am I missing
I can't thank you all enough for your help to this point.
The Import table has the employee ID of each person and a field for each of the 18 pieces of equipment with a date in the field if the employee is licensed.
I was thinking of a query for employee ID if each of the other fields Is Not Null.
Thus I would have 18 querys and append those results to tblCertifications.
However, I can't seem to come up with a way to make it click and there is probably a less messy way then 18 queries. What am I missing
I can't thank you all enough for your help to this point.
