filter report based on calculated value

[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

 

[Arvin Meyer [MVP]]

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.

 

[Michael Steiner]

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.

Hi Arvin!

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

--Michael

 

[Arvin Meyer [MVP]]

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.

 

[Michael Steiner]

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,

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

 

[Pieter Wijnen]

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