Filter property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a filter property in a report that is based on a table.
I have a calculated field on the report that sums the balances on groups of
records. I would like to show the group of records only if the balance
exceeds $1000. How can I write this filter property? I am using Access 2003.
TIA.
 
You can't filter or sort on an "aggregated" value in a report such as a Sum
or Count.

An alternative is to create your aggregate value(s) in a totals query and
add this query to your report's record source. You can then join the
appropriate fields and either filter or sort on the aggregate values.
 
Back
Top