Report format - Access 07

  • Thread starter Thread starter Bob76
  • Start date Start date
B

Bob76

I would like to copy the exact format of a report that I had created earlier
but with a different set of data (another query as data source). How do I do
this? This would save me a lot of time involved in formatting the columns,
rows, fonts, colors, etc. once again. Please advise.

Thanks, Bob
 
1. While the report is NOT open, select it in the Navigation Pane, copy
(Ctrl+C), and paste (Ctrl+V.) Access will ask what name to give the new
copy.

2. Open the new report in design view, and set its RecordSource property.
That's the first property on the Data tab of the Properties sheet, when
looking at the properties of the report (not those of a text box.)

There may be a way to filter the report without having to duplicate it and
create lots of queries. Here's an example where you can filter the report to
a specific date range:
http://allenbrowne.com/casu-08.html
 
Allen,
I did it!!! Thanks so much... You've helped me quite a few times already.
I have another question (tho' this might be an irrelevant and silly
question). Is there a way of having the Report Header print on top of every
page of a report (top of the page header)? If not, that's okay...
I did check a lot of Access books and often times can't find the solution to
some basic database problems... This Discussion Group is a Godsend..
Appreciate your help..

Bob
 
Bob76 said:
Allen,
I did it!!! Thanks so much... You've helped me quite a few times already.
I have another question (tho' this might be an irrelevant and silly
question). Is there a way of having the Report Header print on top of
every
page of a report (top of the page header)?
Click to expand...

Try using the Page Header instead of the Report Header.
 
Back
Top