Table Design for Query Function

[Desstro]

I'm creating a database for our QA department.

So far I have 1 table with EmployeeID as the PK
The rest of the table consists of LastName, FirstName and then a whole list of certifications an employee might have.

The data type for the certifications will be a shortdate, as if to say this is the date they have been certified by the company.

Every 180 days the employee has to be audited for each certification.

An example of a certification field name would be RT1.

My question is how should I set up my table structure in order to create a query that will show employees that will be due for an audit 60 days before their actual due date?

Any suggestions?



2nd question is how do I set the criteria in the query?

[Desstro]

Nevermind...,
I figured out how I want my table structure. Will ask Query question in Query Forum.