I need to know if there is any way to group Access 2003 reports by lots. In other words if there are 95 rows in the query or table, and the user specifies lots by 10, then the rows would be grouped such as:
Lot 1
[Row 1]
[Row 2]
...
[Row 10]
Lot 2
[Row 1]
[Row 2]
...
[Row 10]
....
Lot 9
[Row 1]
[Row 2]
[Row 3]
[Row 4]
[Row 5]
I'd like to be able to do this in one report and not have to use multiple sub-reports.
Thanks
