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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alindler - 17 Jan 2006 20:24 GMT

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?

Reply to this Message

Duane Hookom - 18 Jan 2006 00:22 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 3 lines]
> greater. So, how can I set a filter on the results of the report - aka the
> subtotal?

Reply to this Message