Total for selected column 1

[ZoomerZ]

Hi!
Is there way to insert Total into Access Report for selected columns?
Should that be a formula?

Thanks

 

[THWatson]

ZoomerZ
Try putting an unbound text box in the report footer, with the control source being
=Sum([YourFieldThatIsInColumn1])

and do the same for each column you want totalled.

If you are doing sorting and grouping, you could also put this expression in an unbound text box in the grouping footer.

Tom

 

[ZoomerZ]

Thanks, how can I calculate id field is Text.

I need to calculate by parameter. I have a grouping footer and I am inserting your formula into it so it will count rows.
Every row is 1. I need Number of rows per group.

Thanks

 

[THWatson]

ZoomerZ
Try using Count rather than Sum in the expression.

Tom

 

[ZoomerZ]

Sending my love to THW...I am so DONE with pretty Report, thanks to you...

 

[ZoomerZ]

I just found a glitch in my Report.

My first group has 17 records and my formukla says 17
My second group has 1 record and formula says 18 (should say 1)
My third group has 1 records and formula says 19 (should say 1)

I hope it is simple...THANKS

 

[THWatson]

I need a little more information.

There must be some way to differentiate among the 3 groups. What are the groups? Can you give me the names of the controls in the groups?

Tom

 

[ZoomerZ]

Sure...

every group has a footer/header
------------------------------------------
Executives BusinessUnit CostCenter
text text text
-------------------------------------------
Bieler Garry 2Grt Unique01
Unique02
Unique03
SubTotal BusinessUnits:1 CostCenters:3

3Grt Uniq01
Uniq02

SubTotal BusinessUnits:1 CostCenters:2
Total BusinessUnits:2 CostCenters:5


I hope it is more clear now. Thanks so much

 

[THWatson]

So what is it that isn't totally correctly?

The totals in the group footers, or the Totals in the report footer?

In your example you gave, what doesn't work?

Tom

 

[ZoomerZ]

See, I don't want running total, I want like in my example.
Instead I am getting

------------------------------------------
Executives BusinessUnit CostCenter
text text text
-------------------------------------------
Bieler Garry 2Grt Unique01
Unique02
Unique03
SubTotal BusinessUnits:1 CostCenters:3

3Grt Uniq01
Uniq02

SubTotal BusinessUnits:2 CostCenters:5
(should be 1) (should be 2)

Thanks

 

[THWatson]

Sorry to belabour this, but are you grouping first by Executives, and then secondly by Business Units?

Tom

 

[ZoomerZ]

No, BusinessUnit and Cost Center...
I tried but when posted format went off sorry

I am writing some IIFs to see what I can do, thanks for helping me. I need to show on Monday. Thanks

 

[ZoomerZ]

I wrote in text boxes =IIf(IsNull(Count([Business Unit])),"",(Format(CStr(Count([Business Unit ])))))

and it seems working

Please, look at and tell me if it seems legit function

I will still want your input Thanks

 

[THWatson]

I just made up a little table and plugged in the values you provided.

Then in the report, I did the first grouping on Business Unit, with both a Header and Footer. Then I did a second grouping on Cost Centre but NO Header and NO Footer.

This was the result...
Executives Business Unit Cost Center
Bieler Gary 2Grt Unique01
Unique02
Unique03
CostCenters: 3

3Grt Unique01
Unique02
CostCenters: 2

Now, I probably don't have the table designed the way you have it, so if I try to count Business Units, I get multiples (a count of three 2Grt, and a count of two 3Grt) but I think changing the grouping will give you the result you need.

I haven't analyzed your IIf statement because I worked on this grouping.

See if this works for you.

Tom

 

[ZoomerZ]

and where did you placed boxes with calculation?
Can't make it work, gets me Running Total...

 

[THWatson]

In the Business Unit footer, I put...
=Count([CostCenter])

Tom