filter report based on calculated field

  • Thread starter Thread starter robertm600635
  • Start date Start date
R

robertm600635

I have a totals query that sums [payments] [fees] and [adjustments]. A report
based on this query displays the results. On the report I have a field that
calculates the balance: [fees]-[payments]+[adjustments]. I want to be able to
filter out any records that have a balance of zero but cant seem to get it
right. Any suggestions?
 
robertm600635 said:
I have a totals query that sums [payments] [fees] and [adjustments]. A report
based on this query displays the results. On the report I have a field that
calculates the balance: [fees]-[payments]+[adjustments]. I want to be able to
filter out any records that have a balance of zero but cant seem to get it
right.
Click to expand...

Put that calculation in the query and then filter it in the
usual way.
 
Back
Top