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

[robertm600635]

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?

 

[Maurice]

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

 

[Marshall Barton]

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?

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.