Group item count totals in header

[Steve via AccessMonster.com]

I had a report that grouped contract data by Dept - at the beginning of each
group, I had a textbox which contained the count of that group - the number
of items. My boss decided that they don't want the contracts grouped, but
still want the group totals to show in the report header.

So it would look like:

CONTRACT DATA REPORT

Marketing Dept: 35 Contracts total | Sales Dept 47 Contracts
total | Maintenance Dept: 33 contracts total

Detail record 1
Detail record 2
Detail record 3
Detail record 4
(Listing all records - no grouping)

 

[John Spencer (MVP)]

Use a subreport in the report. Base the subreport on a query that gives you the
summary data.

 

[Steve via AccessMonster.com]

John,
I'll give that a try - thank you very much !

Use a subreport in the report. Base the subreport on a query that gives you the
summary data.

I had a report that grouped contract data by Dept - at the beginning of each
group, I had a textbox which contained the count of that group - the number

[quoted text clipped - 13 lines]

Detail record 4
(Listing all records - no grouping)