Creating my own report template

N

NNester

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?
 
T

Terry

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?
 
N

NNester

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