Breaking Down A Field Into Multiple Fields

[aldo]

I am attempting to create a report that breaks down a field of 'ID' numbers into groups of x. In the sample report below x = 12 and the report will apportion the first 12 'ID's to the first page and textboxes with extra large fonts will signify the start and end of 'ID' numbers for that page.

I believe I can attain my goal if I were able to create a query which broke down the field 'ID' into multiple fields based on x.

Does anyone know how I can create this query, or perhaps suggest another way to create this report using the existing 'ID' data.

Thanks in advance,
Aldo

 

[FoFa]

I think I would create a function that returned a number based on your criteria. So if x was 12, the first 12 rows would return 1, the second 12 would be 2, etc. If it was 4 then the first 4 rows would return 1, the second 4 would return 2 etc. Than you can use this value to sort your rows by and group by in a report.
Any way, as one way to do it.

 

[aldo]

That sounds feasible.

I shouldn't have too much problem figuring out the grouping aspect in the report end of it, but you wouldn't happen to know the code that would assign sequential numbering to x amount of data rows?

-aldo