How to limit the records seen in a report based on a subtotal amount?

[jimmcg]

how can i limit the records seen in an access report based on a subtotal amount?

[beacon]

Hi Jimmcg,

Welcome to Bytes!

Where is the subtotal amount...on a form? Typically, if the subtotal is on a report, the subtotal is created by the records on the report, not the other way around.

Can you provide a few more details about what you're trying to accomplish or maybe an example from your database?

[jimmcg]

Beacon,
i'm looking for the best way to limit records in a report based on a subtotal value, only records above a certain limit. should i be looking at the query to limit this or can i set a variable within the report?

[beacon]

I would do it in the query if possible and if that's the way the report will always run, but you could use the filter property on the report to accomplish the same thing if the report sometimes will run with or without the limit.

Where does the subtotal value come from?

[jimmcg]

The subtotal is done by the grouping feature on the report with the data that is drawn from the query.