Clicky


Can you tell me how to show each group from a MS Access query per page on a MS Access report?  Thanks!!

Each group shows on its own page.

asked 12/08/2011 11:18

superoneio's gravatar image

superoneio ♦♦


4 Answers:
...well if one group has 500 records, it is unlikely that it will be able to "fit" on one page...
Do you mean that each group *starts* on its own page...?

In the most basic sense, you can create a basic report from the query, but then set the "Force new page property of the Detail section to "Yes".

The best thing to do would be to create a report with the wizard and select the "Common" field as the "Grouping" option.
Then set the "Force New Page" property of the "Group Footer" to Yes.

JeffCoachman
link

answered 2011-12-09 at 07:33:09

boag2000's gravatar image

boag2000

...a clarification...
My second suggestion was based on you creating a report from the raw data,  not the existing GroupBy query.
This would list all of the values in the Group...

I just thought I would present both options, as in some cases you might want to see the individual values, but segregate them by a common (Group) field

A sample of both is attached


JeffCoachman
link

answered 2011-12-09 at 07:47:25

boag2000's gravatar image

boag2000

Excellent Solution!!
link

answered 2011-12-09 at 08:06:47

superoneio's gravatar image

superoneio

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×14
×19

Asked: 12/08/2011 11:18

Seen: 263 times

Last updated: 12/15/2011 03:28