Report to show me up-to-date employees

[lpgagirl]

I have a form that tracks employees courses, training ect...The employee along with each course is listed with a bound text box where I input the date that the employee completed the course. I want to be able to print a report that tells me what employees are "current" in their training. All of the courses listed must be renewed every year, so current in this case means as long as the date in each of the fields is not more than a year old the employee is current. How can I achieve this? I was thinking of having a button for qualified employees that opens a report. But how do I create a query to get what I want? Or do I need to run a sequence in code to get the results I need? If so, code and/or examples please. Concurrently, it would also be benificial to have a report that tells me which employees are not up-to-date with their training.


Jeannie

http://thefloyds.50megs.com/index.html

 

[dhookom]

It would help if we could see your tables and fields. We can't tell you how to get some place if we don't know where you are starting from.

I expect your tables might not be normalized but I could be wrong.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lpgagirl]

I tried looking for information on normalized data bases but found nothing here other than reference to them. Do you know where I can find some good info. on how to normalize a DB?

Jeannie

http://thefloyds.50megs.com/index.html

 

[dhookom]

Again, I am not sure if your tables are normalized or not since you haven't provided this level of details. You can find lots of web sites by searching google on "Database Normalize". One site is

http://www.gslis.utexas.edu/~l384k11w/normover.html.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lpgagirl]

Thanks I went to Microsoft and found some good info. You are right my main table is not normalized. I need to make at least 3 different tables from it. I know that I can run the table splitter on access, do you suggest this as the best way to split tables after the fact or should I just manually do it?

Jeannie

http://thefloyds.50megs.com/index.html

 

[dhookom]

I haven't used the splitter since I generally start fairly normalized. I suggest that you make a copy of your mdb and do one manually and then run the splitter on the other.

Come on back if you have questions.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lpgagirl]

Thanks Duane

Jeannie

http://thefloyds.50megs.com/index.html