Report Template

[LG]

If I have built a report that is ran off a query is it possible to leave the
settings as a template to build another report with the same size fields etc
but using a different query?
Let me know if you need more information.
Thank you

 

[Marshall Barton]

If I have built a report that is ran off a query is it possible to leave the
settings as a template to build another report with the same size fields etc
but using a different query?

You can always use Copy/Paste to make a copy (with a
different name) of a report and then use design view to
change the record source property of one of them.

BUT, that would be a maintenance problem when it comes time
to change something in the reports. Better would be to use
some code in the report's Open event procedure to set the
record source to the desired query. How you would set this
up depemds on where/how you determine which query to use.

 

[Klatuu]

Yes, just make a copy and change the Record Source property of the report.