SUm function

A

Alex H

Hi - is it possible in the header section of a group, to sum field1 where
the value of field2 = 1?

Thanks

A
 
F

fredg

Hi - is it possible in the header section of a group, to sum field1 where
the value of field2 = 1?

Thanks

A
Click to expand...

if I understand your question properly, then, in an unbound control's
control source:

=Sum(IIf([Field2]=1,[Field1],0))
 
Top