Adding / Summing up like items

[Guest]

I have built a report that shows approved and pending items for various
projects, now i can have multiple projects and multiple approved and pending
items below each project. I would like to add up the dollar amounts that
correspond to each approved or pending project. I have tried to use the
standard =sum([fieldname]), unfortunately that is adding everything up and
placing that amount under each heading.

Project 1
Approved Items
item a - $10,000.00
item b - $1,000.00
Total = $11,000.00
Pending Items
item c - $12,000.00
item d - $1,000.00
Total = $13,000.00

Project 2
Approved Items
item a - $500.00
Total = $500.00
Pending Items
item c - $12,000.00
Total = $12,000.00


My question is how do you get the "Total" calculated. I would like something
like that...

Thanks and hopefully that makes sense..

 

[Marshall Barton]

I have built a report that shows approved and pending items for various
projects, now i can have multiple projects and multiple approved and pending
items below each project. I would like to add up the dollar amounts that
correspond to each approved or pending project. I have tried to use the
standard =sum([fieldname]), unfortunately that is adding everything up and
placing that amount under each heading.

Project 1
Approved Items
item a - $10,000.00
item b - $1,000.00
Total = $11,000.00
Pending Items
item c - $12,000.00
item d - $1,000.00
Total = $13,000.00

Project 2
Approved Items
item a - $500.00
Total = $500.00
Pending Items
item c - $12,000.00
Total = $12,000.00


My question is how do you get the "Total" calculated. I would like something
like that...

=Sum(amount) in the approved/pending satus group footer
section should work.

OTOH, maybe there's something about the grouping and record
source table/query that you haven't told us yet.

 

[Guest]

I have built a report that shows approved and pending items for various
projects, now i can have multiple projects and multiple approved and pending
items below each project. I would like to add up the dollar amounts that
correspond to each approved or pending project. I have tried to use the
standard =sum([fieldname]), unfortunately that is adding everything up and
placing that amount under each heading.

Project 1
Approved Items
item a - $10,000.00
item b - $1,000.00
Total = $11,000.00
Pending Items
item c - $12,000.00
item d - $1,000.00
Total = $13,000.00

Project 2
Approved Items
item a - $500.00
Total = $500.00
Pending Items
item c - $12,000.00
Total = $12,000.00


My question is how do you get the "Total" calculated. I would like something
like that...

=Sum(amount) in the approved/pending satus group footer
section should work.

OTOH, maybe there's something about the grouping and record
source table/query that you haven't told us yet.

Marshall,
At the risk of sounding stupid, I must admit that I am relatively new to
Access; therefore my next question is how do you group items as you
mentioned. I am not sure if I have done this or not, please send more info...

Thanks,
Scott

 

[Guest]

I have built a report that shows approved and pending items for various
projects, now i can have multiple projects and multiple approved and pending
items below each project. I would like to add up the dollar amounts that
correspond to each approved or pending project. I have tried to use the
standard =sum([fieldname]), unfortunately that is adding everything up and
placing that amount under each heading.

Project 1
Approved Items
item a - $10,000.00
item b - $1,000.00
Total = $11,000.00
Pending Items
item c - $12,000.00
item d - $1,000.00
Total = $13,000.00

Project 2
Approved Items
item a - $500.00
Total = $500.00
Pending Items
item c - $12,000.00
Total = $12,000.00


My question is how do you get the "Total" calculated. I would like something
like that...

=Sum(amount) in the approved/pending satus group footer
section should work.

OTOH, maybe there's something about the grouping and record
source table/query that you haven't told us yet.

Marshall,
At the risk of sounding stupid, I must admit that I am relatively new to
Access; therefore my next question is how do you group items as you
mentioned. I am not sure if I have done this or not, please send more info...

Thanks,
Scott

Marshall,
After a little digging I found that all I needed a was to create a Grouping
Footer to match the Grouping Header. Once I made that correction I placed the
SUM Field there and solved the issue.

Thanks for the hint......

 

[Marshall Barton]

savv32 wrote:
I have built a report that shows approved and pending items for various
projects, now i can have multiple projects and multiple approved and pending
items below each project. I would like to add up the dollar amounts that
correspond to each approved or pending project. I have tried to use the
standard =sum([fieldname]), unfortunately that is adding everything up and
placing that amount under each heading.

Project 1
Approved Items
item a - $10,000.00
item b - $1,000.00
Total = $11,000.00
Pending Items
item c - $12,000.00
item d - $1,000.00
Total = $13,000.00

Project 2
Approved Items
item a - $500.00
Total = $500.00
Pending Items
item c - $12,000.00
Total = $12,000.00


My question is how do you get the "Total" calculated. I would like something
like that...


=Sum(amount) in the approved/pending satus group footer
section should work.

OTOH, maybe there's something about the grouping and record
source table/query that you haven't told us yet.

Marshall,
At the risk of sounding stupid, I must admit that I am relatively new to
Access; therefore my next question is how do you group items as you
mentioned. I am not sure if I have done this or not, please send more info...

Marshall,
After a little digging I found that all I needed a was to create a Grouping
Footer to match the Grouping Header. Once I made that correction I placed the
SUM Field there and solved the issue.

Sorry my reply wasn't clearer.

I'm glad to hear that you unraveled anyway.