Report Criteria?

[ai_enjoi via AccessMonster.com]

Hi!

I have a problem with my report about Accounts Receivable. It is supposed to
show all the Accounts Receivable, regardless if whether they are paid or not.
Now, the problem is that in the textbox "Total", it should only include those
which are not paid,which could be determined by the checkbox "Paid" which is
also shown in the report. If there is a check on the box,it means that the
account has already been paid. The textbox "Total" sums the value from the
textbox "Amount". The values are from the same query, What criteria should
be in placed and where should it be placed? Can someone please help me?

Thanks in advance for those who would help!

 

[Guest]

I'm not quite sure I follow all of this. However, if you want to create a
total in a report of a field named Amount where a yesno field named Paid is
not checked, the expression would be:
=Sum(([Paid]+1) * [Amount])