S
Secret Squirrel
I have two fields on my report, one is "PaymentMethod" and the other is
"ExpenseAmount".
The PaymentMethod can be either "AMEX" or "CASH". How can I create an IIF
statement to sum the totals for each method?
I tried to create these two text boxes on my footer but it didn't seem to
work:
IIF([PaymentMethod]="AMEX",Sum([ExpenseAmount]),0)
IIF([PaymentMethod]="CASH",Sum([ExpenseAmount]),0)
"ExpenseAmount".
The PaymentMethod can be either "AMEX" or "CASH". How can I create an IIF
statement to sum the totals for each method?
I tried to create these two text boxes on my footer but it didn't seem to
work:
IIF([PaymentMethod]="AMEX",Sum([ExpenseAmount]),0)
IIF([PaymentMethod]="CASH",Sum([ExpenseAmount]),0)