filter report based on calculated field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robertm600635 - 04 Dec 2007 20:25 GMT

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?

Reply to this Message

Marshall Barton - 04 Dec 2007 20:48 GMT

>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.

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

Signature

Marsh
MVP [MS Access]

Reply to this Message