conditional report total

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

Guest

Hi to all. I need to do a report total for records with fld1 = 'A' only. Records with fld1 other than 'A' are also printed but need not total it. Any suggestion?

Thanks in advance!
 
Just figured out, =sum(iif(condition, t,f))

----- Harry wrote: -----

Hi to all. I need to do a report total for records with fld1 = 'A' only. Records with fld1 other than 'A' are also printed but need not total it. Any suggestion?

Thanks in advance!
 
Back
Top