Filter a Reports calculated field

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

Guest

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?
 
Andy said:
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?
Click to expand...

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.
 
Back
Top