New page by grouping

A

andrena

Say I'm grouping by a persons Name in a report and they have all thi
information with their name. Is there a way to have the report put eac
grouping onto a new page???

Also, with this report and each grouping is there a way to assign a ne
invoice number for each page and increment each time the report i
run??
 
A

Allen Browne

Open the report in design view.
Right-click on the grey bar representing the group header.
Set the ForceNewPage property to Yes.

Regarding the invoice number, is it possible to increment the number using
text box with these properties:
Control Source =1
Running Sum Over all
and you could also store the highest previously used value in a table,
DLookup() that value, and add it to the running sum. However, this won't be
much use when a client phones you to discuss invoice 345, because you have
not stored the value anywhere. I suggest you really need to create records
for these invoices, and store the invoice numbers, in order to track what is
going on.
 
Top