Help with query or table setup

[Guest]

I am trying to create a database to track employees info and trainings to see if they are late and such. Each employee has numerous trainings they must take and I'm trying to figure out the best way to build this so I can run a query or report that will show which employee has trainings that are past due or late.

I started the first time by just having a table called training with a field called this too that you could chose from a list and pick the training, enter the date taken, it would calculate the expire date, and had an area to check yes if it was late. I had problems with this setup so I tried a separate table for each class, but am also having problems getting a query to run and pull up anything. If I do get it to work, it shows all the classes even if they weren't late (it has the field blank), which is a waste of space. I would like it to pull only those classes that are late and list them by employee. Any suggestions?

 

[Guest]

I'm not sure if if I've understood you correctly.

However, if so, I would suggest at least 3 tables:

1. An employees table: Random autonumber primary key; first name; middle name; last name; etc.

2. A class table: Random autonumber primary key; class name; date; start time; etc.

3. A joining table: 2 foreign keys, one for the employees table and one for the class table; time of employee arrival (which could be left blank for no-shows)

 

[Ernie]

To prevent getting those classes with blank late field,
just add to your query criteria "is not null". Other than
that, what 'hyperlink' said is also true. You need 3
tables, employees, classes, and a linking table with the
times and late flag. An update query could be used to
set/unset your late flag based on the times already
entered.

-----Original Message-----
I am trying to create a database to track employees info

and trainings to see if they are late and such. Each
employee has numerous trainings they must take and I'm
trying to figure out the best way to build this so I can
run a query or report that will show which employee has
trainings that are past due or late.

I started the first time by just having a table called

training with a field called this too that you could chose
from a list and pick the training, enter the date taken,
it would calculate the expire date, and had an area to
check yes if it was late. I had problems with this setup
so I tried a separate table for each class, but am also
having problems getting a query to run and pull up
anything. If I do get it to work, it shows all the
classes even if they weren't late (it has the field
blank), which is a waste of space. I would like it to
pull only those classes that are late and list them by
employee. Any suggestions?