How do I setup the same report for a multiple subgroup?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one report that I want to have it run multiple time for different
"people" but do not want to create 50 of the same report.
 
Roxie,
I'd take the easy way out, and use an Inputbox to ask the user how many
copies they require. The number they input could be used in a For..Next
loop to repeatedly Open the reoport for the required number of times.
To do it auto-magically, you could use the [currentuser] to identify who
is asking for the report, amd look up a [NoOfCopies] value for that person
in a User_NoOfCopies table.

I've never had to do that, but it should work.
hth
Al Camp
 
Please let me try my question again. I do not think I was clear.

I have one report and 50 people who are part of the report.(i.e. Firm 1,
Firm 2, Firm 3, etc). Rather than create 50 queries and 50 Reports (one for
each Firm). Is there a way to use a table or something to always do the same
report for the 50 Firms?
 
Back
Top