Filter a Reports calculated field

[Andy Gibson]

I have a report that draws data from various tables, and makes some
calculations with information from the tables.

I need to run a report that will automatically filter the calculated field
eg. The report will only show the records > 10%

Is this possible using SQL and if so how?

 

[Marshall Barton]

I have a report that draws data from various tables, and makes some
calculations with information from the tables.

I need to run a report that will automatically filter the calculated field
eg. The report will only show the records > 10%

Is this possible using SQL and if so how?

Report's can not filter themselves on a value they are
calculating. The calculation needs to be done in the
report's record source query so the query's Where clause can
filter the records..

As a last resort, a report can cancel a section by setting
the section's Format event procedure's Cancel argument to
True.