Set the a fixed size for the detail section

[Guest]

I am trying to prepare labels in MSAccess 2003 Reports.

I have a group called Stores and each Store has a different number of
customers. Therefore, if store 1 has 3 customers then the next group starts 3
records later. If Store 2 has 5 customers then the next group starts 5
records later.

Conculsion: the total number of lines a group eill have depends on the
number of customers and therefore the groups go out of sync with the label
size.

Is there a way I can tell the detail section that the number of records = x,
independant of the actual number of records?

Many thanks

Nelson

 

[Duane Hookom]

Consider creating a report of stores only as the main report with a
subreport of the customers. You can set the subreport size as required and
don't allow it to grow.