How do I set up a Report Template in Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fiona - 30 Aug 2004 05:21 GMT

I would like to set up a Report Template in Access (2000). I have to run the
same report for in each state for each client (potentially 100s of reports).
I would like to set up a template I can use for all reports thus keeping the
formatting uniform and saving me hours of report formatting!!

Thanks

Reply to this Message

Brendan Reynolds - 30 Aug 2004 12:43 GMT

If I understand your question correctly, I think that what you need is not a
report template, but a report based on a parameter query. For example, if
your report is based on a table that includes fields for the state and the
client name, the following query, as the record source for the report, would
prompt for the state and client name to be included each time it is run ...

SELECT * FROM YourTableNameHere WHERE YourStateNameFieldHere = [Enter Name
Of State] AND YourClientNameFieldHere = [Enter Name Of Client]

Signature

Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

> I would like to set up a Report Template in Access (2000). I have to run the
> same report for in each state for each client (potentially 100s of reports).
> I would like to set up a template I can use for all reports thus keeping the
> formatting uniform and saving me hours of report formatting!!
>
> Thanks

Reply to this Message

Jeff Boyce - 30 Aug 2004 12:44 GMT

Fiona

I may not be understanding what you are trying to do.

In Access, you create a report definition and re-use it many times. You can
change what shows in the report by basing it on a query. If you include
parameters in your query ([state] and [client] in your description), you can
get your "100s of reports"). Or you could group by these two fields in your
report and get one page per combination, running all a one time.

Of course, this will depend completely on how you have structured your data
(which you didn't describe).

Signature

Good luck

Jeff Boyce
<Access MVP

Reply to this Message