summing unique values in 2 seperate footers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ld-runner - 17 Jan 2006 17:06 GMT

i have a report with 2 sorts and 2 footers.
i need to count unique values over the whole group.
i can use a text box control to =1 and sum over group option, however, i am
only interested in the very last entry that method produces.
I do not want to use report footer because that will be used for the report
totals.
I need a way to count unique values from a sort footer. Any ideas?
here is the way data comes over...

customer_id order_id revenue
ABC 123 $50
ABC 123 $45

ABC 234 $35
ABC 234 $45
ABC 234 $55

ABC 345 $100

So i would need to show ABC had 3 orders that totaled $330.
Thanks

Reply to this Message

Duane Hookom - 17 Jan 2006 17:40 GMT

There have been at least three similar questions in the last week.

Add a text box to your Order_ID header section:
Name: txtCountOrders
Control Source: =1
Running Sum: Over All
Visible: No
Add a text box to your report footer section
Control Source: =txtCountOrders

To total the Revenue, use a text box with a control source of:
Control Source: =Sum(Revenue)

Signature

Duane Hookom
MS Access MVP
--

>i have a report with 2 sorts and 2 footers.
> i need to count unique values over the whole group.
[quoted text clipped - 19 lines]
> So i would need to show ABC had 3 orders that totaled $330.
> Thanks

Reply to this Message

ld-runner - 17 Jan 2006 18:02 GMT

its not quite the same...as stated, i do not want to use the report footer.
That will be used for totaling the entire report. I guess i should give more
detail.

ABC 123 $50
ABC 123 $45

ABC 234 $35
ABC 234 $45
ABC 234 $55

ABC 345 $100

WOW 567 $100

WOW 678 $45
WOW 678 $55

so i end up with one footer showing

ABC 3 $330
WOW 2 $200

and my report footer saved for

2 5 $530

> There have been at least three similar questions in the last week.
>
[quoted text clipped - 32 lines]
> > So i would need to show ABC had 3 orders that totaled $330.
> > Thanks

Reply to this Message

Duane Hookom - 17 Jan 2006 20:06 GMT

========
so i end up with one footer showing

ABC 3 $330
WOW 2 $200
========
I assume this is in your report footer. Regardless, you can create a
subreport based on a totals query that groups by totals to get the values
you need. Add the subreport to a section in your main report.

Signature

Duane Hookom
MS Access MVP
--

> its not quite the same...as stated, i do not want to use the report
> footer.
[quoted text clipped - 62 lines]
>> > So i would need to show ABC had 3 orders that totaled $330.
>> > Thanks

Reply to this Message