Access Reports

[Stefan Hellersperk]

I have what is probably a stupid setup question. I am currently building a
basic access database, I have created a many queries each with a specific
criteria, I have setup a report to show the records that match that query, I
would like to apply that report to each different query without having to
edit they layout for each one.

Is there a way to use the same report layout for each seperate query?

Thanks.

 

[Van T. Dinh]

Copy the Report and namne it differently, says, "SecondReport".

Open the SecondReport in Design View and change its RecordSource to another
(but silar, i.e. same section list) Query.

OTOH, it sound like you should use a Parameter Query as the RecordSource for
the first Report and the Parameter(s) filter to only Records that meet the
filtering criteria depending on the supplied values for the Parameters.
When the Report is opened, Access will ask for the Parameter values and only
select the records that meet the filtering criteria.

Check Access Help on "Parameter Query"

 

[Guest]

Hi Stefan,

Your question is not stupid at all. If you send me a private e-mail message
with a valid reply-to address, I'd be happy to send you a sample. My e-mail
address is available at the bottom of the contributor's page indicated in my
signature. Whatever you choose, please do not post your e-mail address (or
mine) to a newsgroup reply. Doing so will only attract the unwanted attention
of spammers.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Van T. Dinh]

Sorry, sticky keyboard. The second paragraph should read:

Open the SecondReport in Design View and change its RecordSource to another
Query (similar as the original Query for the Report, i.e. same selection
list).

 

[Stefan Hellersperk]

Thanks Tom, I've sent you that private email, your help is much appreciated.

 

[Guest]

Hi Stefan,

I just now sent a reply that includes (4) file attachments.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________