Report Template

  • Thread starter Thread starter LG
  • Start date Start date
L

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
 
LG said:
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?
Click to expand...


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.
 
Back
Top