Sum of field by criteria of other field

[mejia.j88]

hi all,

i have a report in which i would like to display the quantity produced per shift depending on what size the part is.

i have a field that says total leadbonded which is just a number. these parts are either size .04, .063, .125 and .250 of an inch.
i would like to have the report footer display the total for each of these. there are times when the sum would be 0.



right now i have this on my report in a text box: =IIf([cut_size]=0.125,Sum([total_leadbonded]),0)

but it is giving me zero.

any suggestions?

thank you all in advance.
jorge

[pbaldy]

Try

=Sum(IIf([cut_size]=0.125,[total_leadbonded],0))

[mejia.j88]

>.<
thanks!

[mejia.j88]

In a semi-related question:

I'm using 4 text boxes under a footer to show this data, specifically, the Work Shift footer. this shows me what was done first, second and third shift.

if i want the daily total, i will put it under report footer.

My question: is it okay to copy and paste the same text boxes i used under W Shift footer in the report footer?
does this violate any sort of db rules? consequences ?

[pbaldy]

does this violate any sort of db rules? consequences ?

I hope not, because I do it all the time.

Seriously, it's not uncommon to want something in both the group and report footers, to get group and overall totals. I see no problem with it.