Apply Layout to other Reports

[mypig7]

I have created a query based on a table (named it query 1)

I then created a report (call it report 1) based on query 1 and changed the layout which took some time to get just right.

I now want to create a report for 10 other queries, all similar to query 1 and want to apply the exact format that I chose for report 1, with the same layout and colours etc.

Is there an easy way to do this.

Thanks

 

[Norie]

I'm not 100% sure what you are looking for but here are 2 ideas.

When viewing the report in design view goto Autoformat>Customize... and choose Create a new Autoformat...

Or again in design view change the Record Source to the other queries and save with a different name.

With the second you will probably need to change some of Control Sources.