Originally Posted by
fishhead
HI I have a continuous form with a check box field that i would like to sum totals on.
currently i have a txt box in the form footer as follows: =Sum([Buy Rate])
This gives me the total of all the records in the table.
What i would like to do is only total the [Buy Rate] fields of the boxes that have the [pymt requested] check box clicked.
Can anyone tell me how to alter the =Sum([Buy Rate]) expression to only show the records with the check box clicked?
thanks in advance.
Another method or readability:
Code:
=Sum(IIF( [pymt requested],[Buy Rate],0))
or
Code:
=Sum(IIF([pymt requested]=True,[Buy Rate],0))