filter report based on calculated field

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?
 
M

Marshall Barton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Segregate Outstanding Payment 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access ADP Report problem 1
Sum of unbound formula field column 4
account statement 1
Get totals from sub report to main report 1
Running Total from a calculated value 2
Summing the value of two fields 11

Top