SUM using two feilds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like the report to give me a Sum in a text box but only if it meets
the criteria of two fields. I know how to do it for one. I have been using
the following for just one field.
=Abs(Sum(Left([ED_Code],1)="L"))

I would like to have it also check a second field [AFQT] that is Greater
that 49.

Thanks

Keith
 
Back
Top