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!

 

[Cindy]

The easiest way to do this would be to add a field in the underlying
query for the report called something like PdAR. If your accounts
receivable amount field is called curAmnt and your Paid field is a yes/
no field, then the formula for your new field would look like this:
PdAr: Iif(Paid=true, curAmnt,0)

Add the field to the detail section of your report (but hide it), and
do a summary of it in the report.

Cindy