Group item count totals in header

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)


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200508/1
.

Relevant Pages

  • Re: Group item count totals in header
    ... Use a subreport in the report. ... > I had a report that grouped contract data by Dept - at the beginning of each ... > Detail record 1 ...
    (microsoft.public.access.queries)
  • Re: Problem filtering detail records
    ... Why can't you calculate the values in the group header as I ... >But I don't know the totals until the group footer? ... >>>In a report, I want to be able to supress the details section if the total ... >>>detail record it works fine, but if there is just one detail record in the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Show detail rows in report with or without data using VBA?
    ... > followed by a number of empty rows to complete the detail rows to ... >> Dim intPageHeadHeight As Integer ... >>>I have a report that has a similar look to an existing paper form. ... >>> subtract detail record count from 10 ...
    (microsoft.public.access.reports)
  • Re: Keeping total in section footer with last detail?
    ... You only want to break on the last detail record for the group. ... >report is filtered. ... You can easily read the Filter property, ... You can determine the last detail by having a group header ...
    (microsoft.public.access.reports)
  • Re: Breaking a wide report into several pages
    ... I tried that but it separated each detail record into one page. ... > Add a page break control to your report (in the Access tool box) at ... > header as necessary. ...
    (microsoft.public.access.reports)