Filtering Values in report from a function

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

Guest

Have had to use functions to calculate alot of values. The product of many
are zero which i would like to filter on the report. It will not work within
the underlying query as there are too many null values which have to be
changed to zeros! Is this possible to make the code skip a record if the
product of multiple functions is zero? Can this be done from the print
detail section of the report?
 
Another approach would be to create another query that uses the output of
the first query (that uses the function). In that second query, you could
use the criteria to eliminate those you don't wish to see.
 
Thank you i will try using the functions in the query instead of the report.
Using functions to calculate totals - the figures double when printing the
report from print preview, i assume this is easy to stop. Many thanks
 
Back
Top