Grouping records per sheet

  • Thread starter Thread starter ILIRI
  • Start date Start date
I

ILIRI

I need to Group somehow records to one report in order to achieve print out
of particular form that we use at work. Currently we use MS Word for this
task and I want to simplify this task with MS Access, so far so good until I
came to this barrier:

I need records grouped so the records from the table appear in groups of 3
in one page
Page1 Record 1,2,3
Page2 Record 4,5,6
PageX Record x1,x2,x3...

One records has about 20 various items like: text, number, check box ....
I have pasted original layout of the MS Word form for my MS Access report
and inserted fields from my table/query to the designated spots of the
form.
So far I ended with the result of having report displaying:
Page 1 Record 1,1,1
Page 2 Record 2,2,2 or

Page 1 Record 1,2,3
Page 2 Record 1,2,3




__________ Information from ESET NOD32 Antivirus, version of virus signature database 4784 (20100118) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 
You could just set the heights of your sections so a single detail section
will render only 3 times per page.

Otherwise, you can add a text box to the detail section:
Name: txtCount
Control Source: =1
Running Sum: Over All
Visible: No
Add a PageBreak control at very bottom of the detail section:
Name: PgBrk

Then add code to the On Format event of the Detail section
Me.PgBrk.Visible = ( Me.txtCount Mod 3 = 0 )
 
Back
Top