filter report based on calculated value

  • Thread starter Thread starter Michael Steiner
  • Start date Start date
M

Michael Steiner

Hi all!

I need to filter a report on a value i am calculating within the report.
Calculating the value within the underlying query would require me to do
several joins, which i dont want do do.

Is there any way to accomplish a filter on a calculated value?

best regards,

--Michael
 
Once the source of a report is defined, it can only be changed by an event
in a form. Report record sources are fixed after opening.
 
Arvin said:
Once the source of a report is defined, it can only be changed by an event
in a form. Report record sources are fixed after opening.
Click to expand...

Hi Arvin!

Thanks for your response.
Is there a way to set a complete record invisible depending on
a specific value within it?

--Michael
 
Even better, you can use a query to show all of the records which meet a
criteria, and none of the records which do not. Then use that query as the
recordsource for your form or report and it will accomplish your goal.
 
Arvin said:
Even better, you can use a query to show all of the records which meet a
criteria, and none of the records which do not. Then use that query as the
recordsource for your form or report and it will accomplish your goal.
Click to expand...

Arvin,

This calculation would require me to do nested JOINS over 5 tables, if i
try to do this, Access responds with "Join expression not supported".

So i think i _have to_ calc the value within the report - meaning i also
have to do the filtering within the report.

Is there really no way to filter on calculated values other than within
the record source query?

--Michael
 
Usually that means errors in Left /right join

ie

A LEFT JOIN (B INNER JOIN C ON B.B = C.B) ON A.A=B.A

HtH

Pieter
 
Back
Top