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.
 

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

filter report based on calculated field 1
Balance Forward 4
Filtering Report Data 3
Stop running sum(Over All) when customer change 2
Calculate difference or Change between records 2
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Filtering A report using two Parameters 2
Last record backcolor 2

Back
Top