How to create a form type report

G

Guest

I was wondering if someone could give me a bump in the right direction. We
have a database with all our employees in it and also all of their trainings,
write-ups, etc. Our employees can lose a portion of their raise if they have
a mark in 1 of 3 categories, Trainings, med errors, or Performance
Improvement Discussions (PID). Currently I have queries that will pull up if
anyone has a late marke, one for those who are missing trainings, one that
counts the number of PID's and one that counts the number of Med errors.

I would like to be able to set up a report that will put the employees name,
and then list what they have late or a mark in, and automatically do this for
each employee but kind of need a bump in the right direction as to where to
start. The PID and Med query both have date parameters that one enters. The
training queries just generate when selected. If more info is needed, let me
know since I know this is a vague description.
Thanks
 
D

Duane Hookom

You haven't given us much information about your table structures or data.
It doesn't seem like there is much relationship between tables other than an
employee ID. You may be able to create separate subreports and place them on
a main report that is based on an employee table.

You should not use parameter prompts for criteria. Use controls on forms.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top