How do I select "selected records" to print in Access?

[Guest]

I have a database where my information is seperated by month. How do I print
out "selected records"? Meaning, I want to print out one month at a time and
have each month on a seperate sheet.
Thanks

 

[Allen Browne]

Presumably you have a date field (such as InvoiceDate) in the source of the
report?

If so:
1. Open the report in design view.

2. Open the Sorting And Grouping dialog.
Select the date field.
In the lower pane, choose:
Group Header yes
Group Interval Month

3. Access added a gray bar. Set its Force New Page property to Before.

 

[Marshall Barton]

I have a database where my information is seperated by month. How do I print
out "selected records"? Meaning, I want to print out one month at a time and
have each month on a seperate sheet.

It sounds like you want to use the report's Sorting and
Grouping feature. Open the report in design view and use
the View - Sorting and Grouping menu item. Then select your
date field in the Field columnm and in the bottom part of
the window select Month in the Group On property and specify
Yes in the Group Header.

Back in the report, add a text box bound to the date field
to the group header section.

Double click in a blank area of the group header to display
the group header ection's property sheet and set the Force
New Page property to Before Section.

 

[Guest]

Thank you. What gray bar are you speaking of?

 

[Allen Browne]

In report design view, when you add a report header group, Access displays
it as a new section above the detail section. The group header appears as a
gray bar accross the report (in design view.)