How do I set criteria or filter the results of a subtotal in a rep

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

Guest

I created a report based on a table of property listings. Under one
location(say #15), there can be many buildings(A, B, C, etc). I needed an
overall sum of location #15 so I created a report and subtotaled each
location #. I need the report to only print for locations valuing $300,000 or
greater. So, how can I set a filter on the results of the report - aka the
subtotal?
 
Create a totals query that calculates the values you want to filter on. Add
this query to your report's record source and join the appropriate fields.
Add the totalled value your query grid so that it is available to your
report. Use it to filter the results.
 
Back
Top