Grouping in a report

[TrackStar]

I have a database that pulls a random group of 5 results everytime. Is it possible to pull the top 100 and split that into groups of 5?


If that is not possible can I pull different random groups of 5 from the same database into a report? The formating for designing an Access report has not let me yet.

The purpose of doing one of these things is to cut out duplicates and printing 1 document.



Thank you for your time.


Mike

[June7]

That doesn't really explain why need groups of 5. You can pull the top 100 and output on report. The 100 records would also be random?

[TrackStar]

The formating is the most important part of the report. I am trying to fit three groups of five ranadom results on each page and I need ten pages. I would cut these pages into thirds creating 30 7" by 3.5" pieces of paper.

These small pieces of paper would be written on to check daily inventory counts.

I want to use one database so there would be no repeats of the random data, but I cannot seem to format access reports to do so.

[June7]

I still don't understand the 'random' aspect to your issue. Why would an inventory effort use randomly selected records? Don't you have to count everything in stock? Also, 3 groups x 5 results x 10 pages = 150 records.

You want a page break after every 15th record? Review:
http://support.microsoft.com/kb/209006
Another syntax for the Format event code:
Me.PageBreak.Visible = Me.tbxCount Mod 15 = 0
The Format event executes only during PrintPreview or direct to printer.

The real challenge is 'grouping' every 5 records so can create white space between the groups. Review:
http://allenbrowne.com/ser-12.html
This technique will leave white space the same height as a single record in the Detail section. Any method to create more white space will probably involve more complex VBA code and I have no idea what that code would be.

[epb]

Hello June 7,

I know this is after the fact but an explanation on inventory... In many cases an inventory can be performed through cycle counting. X number of random locations or products checked every X number of weeks or months. Then, Over time, the randomness allows for a good cross section of inventory to be examined. This is sometimes preferred to a complete inventory on say a yearly basis.