Connecting Tech Pros Worldwide Help | Site Map

Summarizing Multiple Lines in a report

 
LinkBack Thread Tools Search this Thread
  #1  
Old April 16th, 2006, 01:45 PM
BigNasty
Guest
 
Posts: n/a
Default Summarizing Multiple Lines in a report

I have created a report, where there is multiple items with different
values in a group that i total up at the end:


App 3
App 3
App 2
Com 1
Com 2

Total = 11

The approve is groupped by a header. I would like the report to total
all the like values on one line and produce a final total:

App 8
Com 3

Total = 11

Thanks!


  #2  
Old April 16th, 2006, 04:05 PM
Larry Linson
Guest
 
Posts: n/a
Default Re: Summarizing Multiple Lines in a report

It's not clear to me what you have, nor how it is grouped, and those items
of information are necessary to give you a useful answer. Tell us the Field
names of the items in the Table or Query that is Record Source of the
Report, or the Control Names, and identify which are Field/Control Names and
which are values. I presume that the Field used for Grouping is not one of
these... if so, you could total the values in the Group Footer.

Larry Linson
Microsoft Access MVP


"BigNasty" <lintonra@gmail.com> wrote in message
news:1145194129.591815.78550@g10g2000cwb.googlegro ups.com...[color=blue]
>I have created a report, where there is multiple items with different
> values in a group that i total up at the end:
>
>
> App 3
> App 3
> App 2
> Com 1
> Com 2
>
> Total = 11
>
> The approve is groupped by a header. I would like the report to total
> all the like values on one line and produce a final total:
>
> App 8
> Com 3
>
> Total = 11
>
> Thanks!
>[/color]


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.