Calculations in a Report

[Guest]

I am working on a report that will list by tent # (aka customer #) return
inventory by box. Each box has a unique bar code and is in the database as a
box number. Each box may contain one item or dozen of items. Each tent may
return one box or dozen of boxes.

What I need to accomplish is to give a total value of each box, then a total
value for each tent #. I have accomplished the total tent # return value,
but I can not seem to get a box value, when I try to sum the field
(valueofitem) in the box group footer, I get the total value of all the boxes
returned by the tent, not the sum of just the box #.

Any help would be appericated.

 

[Carma]

I am working on a report that will list by tent # (aka customer #) return
inventory by box. Each box has a unique bar code and is in the database as a
box number. Each box may contain one item or dozen of items. Each tent may
return one box or dozen of boxes.

What I need to accomplish is to give a total value of each box, then a total
value for each tent #. I have accomplished the total tent # return value,
but I can not seem to get a box value, when I try to sum the field
(valueofitem) in the box group footer, I get the total value of all the boxes
returned by the tent, not the sum of just the box #.

Any help would be appericated.

You didn't mention having any other groupings so I'm assuming you don't have
any, and if so then thats the cause of your problem. You need to create
groupings for your tent#, Box code and Items in that order with Group Headers
for all and a footer for Box code(like you already have) and put the
appropriate fields in each header. Once done, your Sum([valueofitem]) should
work fine.

 

[Guest]

Thanks, I tried that. It gives me each items value (already a calculation
based on price level in the query) not a total of all items in one box.

Any other suggestions?
--
Lynette

I am working on a report that will list by tent # (aka customer #) return
inventory by box. Each box has a unique bar code and is in the database as a
box number. Each box may contain one item or dozen of items. Each tent may
return one box or dozen of boxes.

What I need to accomplish is to give a total value of each box, then a total
value for each tent #. I have accomplished the total tent # return value,
but I can not seem to get a box value, when I try to sum the field
(valueofitem) in the box group footer, I get the total value of all the boxes
returned by the tent, not the sum of just the box #.

Any help would be appericated.

You didn't mention having any other groupings so I'm assuming you don't have
any, and if so then thats the cause of your problem. You need to create
groupings for your tent#, Box code and Items in that order with Group Headers
for all and a footer for Box code(like you already have) and put the
appropriate fields in each header. Once done, your Sum([valueofitem]) should
work fine.

 

[Carma via AccessMonster.com]

Thanks, I tried that. It gives me each items value (already a calculation
based on price level in the query) not a total of all items in one box.

Any other suggestions?[quoted text clipped - 15 lines]

appropriate fields in each header. Once done, your Sum([valueofitem]) should
work fine.

Strange cause I actually created a samply database myself to test this and it
worked perfectly. All I can think is you must have you summation formula in
the wrong footer. Like if you put the summation formula in the tent footer
you would get the sum of all items in each tent, if in the box footer the sum
for each box and so on... Beyond this I don't know what else to say. Maybe
someone else has a suggestion or better understanding of your problem.

 

[Guest]

As you nest your groupings within the report

ie...

tent#1 header
box#1 header
detail#1 ValueOfItem#1
detail#2 ValueOfItem#2
box#1 footer CountOfDetail of box#1 SumOfValue of box#1
box#2 header
detail#3 ValueOfItem#3
detail#4 ValueOfItem#4
detail#5 ValueOfItem#5
box#2 footer CountOfDetail of box#2 SumOfValue of box#2
tent#1 footer CountOfBox of tent#1 CountOfDetail of tent#1 SumOfValue of
tent#1
tent#2 header
.....

if you conceptualize the above report layout - it may help you determine
where to appropriately place your Counts or Sums in which Footers to arrive
at the results you are looking for.

this is my first response so let me know if this was any positive help or not

 

[Guest]

You think like I do so yes this was very helpful the way you laid everything
out and you accuatly gave me a new idea, box count. I think the boss will be
impressed that I can give them the number of boxes returned by location. We
may be able to use this information in the inital order delivery aka if an
area is returning 60% sparklers, we should send them so many next season.
Thanks a bunch.