Coppying Reports

[Guest]

Is it possible to copy the format of a report and use it for other queries
that have the same information? Basically, I have reports for three managers
that have teams under them. I have a query for each manager. I have created a
report for one of the managers. Is there a way to do the same report for the
other queries without doing it step-by-step?

 

[Guest]

Hi

It seems a lot of work to make new reports that are the same as each other.
You could have a combo box (or option group - there are only a few managers)
and use this to set the criteria of a column in the query.

Something like this in the manager criteria of the query should do it

Manager:Forms![NameOfForm]![Field]

 

[Guest]

ooops - should be just
Forms![NameOfForm]![Field]

not
Manager:Forms![NameOfForm]![Field]