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.
 
You must log in or register to reply here.

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

Group Rows by Subtotal or Count 1
Subtotals every X number of records 4
Footer subtotal parameter prompt error 1
subtotal of total of some of the groups 6
Summing expressions per group in a report 3
Subreport with no records 8
Reports Grouping 4
Filtering a report based upon a subtotal 2

Back
Top