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