Copy design in report

U

Udayan

I have 10 groups, for example A,B,C,D,E,F,G,H,I,J.
Also i have 10 quires to show each groups.
I have made a report from quire A.

My question is that is there any way to copy the same format in the report A
to all other reports.
 
D

Douglas J. Steele

Why do you need ten queries and ten reports?

You can create a parameter query that will prompt for which group, and base
the report on that parameter query.

You can also create a report that reports on each of the 10 groups (putting
in a page break after each group, if you like), and you can pass a Where
clause when you open the report.

If you're determined to have ten separate reports, copy your existing report
and change the RecordSource property to point to the appropriate query.
 
Top