Sum in a report

Ptrif · May 19, 2003

I have a report that reports a YES or NO for a "reshipped" field I am trying to get a count at the end of the report on how many entries were marked a yes, i am trying to use the string below and i get an error about being to complex or incorrect...please help!!

=Sum(IIf([reshipped]="YES",1,0))

thanks for any input!!

Ptrif

CosmoKramer · May 19, 2003

Try:

Code:

=Abs(Sum([reshipped]))

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Sum in a report

Ptrif

Technical User

CosmoKramer

Programmer

Similar threads

Part and Inventory Search

Sponsor