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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

briguy - 05 Mar 2007 20:21 GMT

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

Signature

briguy

Reply to this Message

Allen Browne - 06 Mar 2007 01:04 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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

Reply to this Message

briguy - 07 Mar 2007 13:09 GMT

Thank you. What gray bar are you speaking of?

Signature

briguy

> Presumably you have a date field (such as InvoiceDate) in the source of the
> report?
[quoted text clipped - 16 lines]
> > have each month on a seperate sheet.
> > Thanks

Reply to this Message

Allen Browne - 07 Mar 2007 13:27 GMT

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.)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thank you. What gray bar are you speaking of?
>
[quoted text clipped - 19 lines]
>> > and
>> > have each month on a seperate sheet.

Reply to this Message

Marshall Barton - 06 Mar 2007 01:26 GMT

>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message