'group by' on a report

[kati h]

I'm trying to set up an invoice with certain information printed only once.
Since this information is carried on all the query records, how do I tell it
to do this. The rest of it is summarized and will print out accordingly.

Thanks!

-- kati h

 

[JamesDeckert]

If you place the item in the report header or the report footer, it will
print at the top or bottom of the report.

James

 

[Marshall Barton]

I'm trying to set up an invoice with certain information printed only once.
Since this information is carried on all the query records, how do I tell it
to do this. The rest of it is summarized and will print out accordingly.

With the report open in design view, use the Sorting and
Grouping window (View - menu) to specify the field your want
to group by. Use the group properties in the lower part of
the window to specify that you want a group header and/or
footer section to place the common fields and group totals.

You can have multiple group levels so you could also group
on an invoice number field and proint multiple invoices in
one run.