Setting up a training database help!

[Sweetnuff38]

I have a table with the following fields

flddate
fldclassname
fldemployeename
fldstatus

I have data entered all current employee training and dates that training was done.

I am looking for an explanation on how I can set it up so i can see who of the employees have not recieved the training.

I am also looking for code for the query to calculate recurrent training dates (when the next training is due for each employee) Dates of initial training for each employee may be different, as well the training may be required every one year or every two years etc.

I am hoping that I am explaining this more clearly in hopes to get some input back from the experts on this site.

Thanks in advance.

 

[scouser]

Normalize

Hi. Firstly I would Normalize (create seperate related tables for classes, employees etc...). You could then have a class allocation table (ClassID, EMPID), you could then query this table.

tblClasses (classID, ClassName etc....)
tblEmployess (EmployeeID, Firstname, Surname etc....)
tblClassAllocations (ID, ClassID, EmployeeID)

Plenty out there on Normalization, hope that helps a little.
Phil.