How can I group the record shown in my report into 5 record each group?

[Michael Franz]

Hi! I am quite new in access and had not taken a programer course. I just learned access through research, so please do understand me cause I realy need help on this one. Any info is very much appreciated.

I had a report based on a query that shows records of Items that had not been printed yet. I've done this by having a field with a check box that is automatically updated once I already printed that record. So, the next time I have a new record it won't show again in my query.

My problem is when I have new unprinted records shown in my report, I want it to show only five records per page and with a separate sum for each page irregardless of what record the page shows.

I had tried setting the group, sort, total function in my report to-

group by: transaction number field of my records
sort by: smallest to greatest
interval: 5's
had my group shown together in one page

But it is grouping it by the last digit of my my stock number. For example, 48 and 49 is grouped together and 50,51,52 is in another group. I want it to be grouped in first 5 record group, second 5 record group and so on in an ascending manner. In short, I just want it to be grouped by 5 records in each page printed, with a sum for of my cost field for each group.

Thanks in advance.

[NeoPa]

If you want the report to show only 5 records per page then only allow space for 5 records on the page.

Totalling can be done in the Page Footer section to capture totals for the page itself.