do not display records on report based on value from calculated fi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a text box that calculates the balance owed by a client.
i would like to prevent any records with a $0 balance from showng up on the
report. How would I go about that?
 
Create a query for the report. Add the calculated field (textbox) to the
query and put the parameter > 0 in the added field. This should show only the
records that have a balance greater than zero.

The added field could look something like this:

Total:[field1]*[field2]

replace the fieldnames with the appropriate fieldnames and the mathematical
operator with the one you need.

hth
 
robertm600635 said:
I have a report with a text box that calculates the balance owed by a client.
i would like to prevent any records with a $0 balance from showng up on the
report. How would I go about that?
Click to expand...


Generally, you should do the calculation in the report's
record source query. Then you can filter the zero total
data out so the report never sees it.
 
Back
Top