No more a case of hitting the wrong button and then not editing it fast enough before you responded back.

Anyway here is how I would handle it.

I would only use two tables. One with customer information and the other with the detail information.

At the end of the month do the following before you print the invoices.

Join the customer table with the detail table summing by customer number. This gets you a table with customer data and the summarized shipped data.

Then do another join of the above created table with the detail shipped table.
Now you have a record with customer data, summarized data and all the detail data.

Select this table

Create your invoice by putting the customer and summarized data fields in the header band of the report and the detail shipped data in the detail band of the report. Set page breaks on customer number.

Hope this helps
Gaylen














>Hi mate - I just got a reply from you which was a copy of my post - is it a case of "the clue is in the question!" LOL