New street, print new page

[Acda]

Hi there,

I've got a little problem, but I think there's an easy solution. I'm working with a database with different addresses. I've made a layout with several records (adresses) on 1 page. However, when a new street begins I would like him to start a new page. So, for example if I can put 30 records on 1 page and the first street only has 10 records, the other should stay empty and on the second page should begin the new street.

I think it has something to do with layout parts, but just can't find it.

Thx in advance

[LiveOak]

When you say "new street begins" do you mean new address record begins?

-bd

[jasonwood]

I'll take a stab at this...

First, it has nothing to do with how you enter records (imagine if a new address was created between two previous addresses, or even a new unit number for that matter)... you don't want to depend on addresses being entered in perfect order.

You will need to have a separate street name and street number field, so that you can group records by street name. You'll also need to make sur that the street name is typed exactly the same way on each record with that street name.

Use the "New Report" assistant to create a report which groups by street name. After you've created the report, go into layout mode, go to "Format > Part". For the subsummary, select the option to "page break before each occurrence".

[Acda]

Thx, it works !