Need to know a way I can restrict what I want in a report

[Terry]

Ok The problem starts off with my 2 tables. One has
employee information like name, ID number, and department.
The other has training information such as what you were
trained in and etc. The employee information has a column
for what department they are in. I need to know how to
create a report so that when you click on the report it
pops up with a form asking which department you want to
see training for. Then all the people who have received
training in that department will pop up. Also that would
need to be a drop down menu because they only have so many
departments to be in.

Thanks
Terry

 

[Terry]

Can someone please help me here
Terry

 

[Alp Bekisoglu]

Hi Terry,

First of all I'm not one of the experts here so if my suggestion does not
work, please do remember this fact.

On your problem, why don't you make a form where you can choose the
department and call your report from there. Thus you can pass the department
name/definition or such to the report and only retrive the related data.

Just an idea.

Alp