SUm function

  • Thread starter Thread starter Alex H
  • Start date Start date
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
 
Hi - is it possible in the header section of a group, to sum field1 where
the value of field2 = 1?

Thanks

A

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

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