Adding / Summing up like items

S

savv32

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..
 
M

Marshall Barton

savv32 said:
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.
 
S

savv32

Marshall Barton said:
savv32 said:
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
 
S

savv32

savv32 said:
Marshall Barton said:
savv32 said:
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......
 
M

Marshall Barton

savv32 said:
savv32 said:
Marshall Barton said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top