Select an Employee

[bhrosey via AccessMonster.com]

I need to run a report from a query where I have EmpName, EmpShift, DateComp
as fields among others containing information about safety hazards that
employee has turned in. So far I have a dialog box set up so that a user can
select whether to pull up information about the entire shift or items that
were completed within a certain date range. I also want to be able to see
everything a certain employee has turned in, but I can't get it to work for
some reason. I've tried using parameters, but it doesn't work. I don't know
what else to try. Please help!

 

[Carl Rapson]

I need to run a report from a query where I have EmpName, EmpShift,
DateComp
as fields among others containing information about safety hazards that
employee has turned in. So far I have a dialog box set up so that a user
can
select whether to pull up information about the entire shift or items that
were completed within a certain date range. I also want to be able to see
everything a certain employee has turned in, but I can't get it to work
for
some reason. I've tried using parameters, but it doesn't work. I don't
know
what else to try. Please help!

You're going to have to give a lot more information about what you're trying
to do and what you've tried. Is the "dialog box" a form that you created? If
so, how are you successfully selecting the other fields, how did you try to
select the employee, and what problem did you encounter ("can't get it to
work" and "doesn't work" can cover a lot of issues).

Also, it might help to see the SQL code for your query.

Carl Rapson