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

Get totals from sub report to main report 1
Access ADP Report problem 1
Filter report to only show current record 4
calculate when subrep has no records 2
Show only clients with balances 5
=iif Calculated field in report? 3
Report Calculations 1
How do I sum a subreport and put the value in the main report 1

Top