Create Multiple Reports based off Query Field

[CindiN]

I have a query that includes a multi-value parameter and I'm trying to figure out how to create a separate report based off each value.

The query lists courses taken by each employee, and I have a parameter that allows the user to type in multiple employee names. So in the parameter box, they can type Joe;Frank;John and the query results will show all the courses taken by each of these 3 names. Now, how do I get the Report to print 3 separate reports for each name? Right now, it will only print one report for the 1st name.

Thank you so much for any assistance.
CindiN

 

[CosmoKramer]

Are you groupung the report by the employee name field? If the query returns the 3 employees you are looking for, you should be able to group on the name field and force a new page after each name.

Would that be good enough?

 

[CindiN]

Thanks Cosmo....That's great! I hate that parameter box, wish you could create a drop down list in the parameter box and be able to choose multiple names. But that's another day another problem.

Thanks so much, I really appreciate your help!
CindiN

 

[CosmoKramer]

CindiN,

You can do that with list boxes...Check out the MultiSelect property in Access help.....

 

[CindiN]

Oooooo the answer to my prayers! Thanks Cosmo