'group by' on a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kati h - 31 Jan 2007 00:11 GMT

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

Reply to this Message

JamesDeckert - 31 Jan 2007 00:40 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> -- kati h

Reply to this Message

Marshall Barton - 31 Jan 2007 15:31 GMT

>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message