Creating my own report template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several reports that I want to have the same graphic, footer info, page orientation & margins, although each report has different fields from different queries. I couldn't locate much info through Help on creating my own templates, as you can do in Word. Can anyone send me in the right direction?
 
Nancy,

There is not a "template" functionality in Access (that
I'm aware off). If you have a common header or footer such
as as a company logo or standard terms and conditions
create a report with the common information and drop it
onto each report as a sub report. This has the advantage
of only one report to maintain if (when) the common stuff
changes.

As to your other post: The query will have something like
[enter report date criteria] you can add a control to your
report and put EXACTLY this as the control source. eg
="Report for " & [enter report date criteria].
As an aside, I usually use a form to enter my criteria and
point at the form's control in my query and in my report.

HTH,

Terry
-----Original Message-----
I have several reports that I want to have the same
graphic, footer info, page orientation & margins, although
each report has different fields from different queries.
I couldn't locate much info through Help on creating my
own templates, as you can do in Word. Can anyone send me
in the right direction?
 
Thanks very much for your help on both questions.
Nancy


Terry said:
Nancy,

There is not a "template" functionality in Access (that
I'm aware off). If you have a common header or footer such
as as a company logo or standard terms and conditions
create a report with the common information and drop it
onto each report as a sub report. This has the advantage
of only one report to maintain if (when) the common stuff
changes.

As to your other post: The query will have something like
[enter report date criteria] you can add a control to your
report and put EXACTLY this as the control source. eg
="Report for " & [enter report date criteria].
As an aside, I usually use a form to enter my criteria and
point at the form's control in my query and in my report.

HTH,

Terry
-----Original Message-----
I have several reports that I want to have the same
graphic, footer info, page orientation & margins, although
each report has different fields from different queries.
I couldn't locate much info through Help on creating my
own templates, as you can do in Word. Can anyone send me
in the right direction?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top