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

Can someone please help me here
Terry

>-----Original Message-----
>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
>
>
>.
>

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

"Terry" <(E-Mail Removed)> wrote in message
news:109d501c41291$ee4e18f0$(E-Mail Removed)...
> 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
>
>