Criteria on field calculated form another calculated field

  • Thread starter Thread starter Max Moor
  • Start date Start date
M

Max Moor

Hi All,
I have a query with a number of calculated fields. Further, one of
the fields is calculated using values from the other calculated fields.
Everything worked fine...

Then I decided I'd like to filter the query on the "calulated from
calculated" field. The criteria is simply "> 0." When the query runs, it
prompts me for one of the calculated fields in the criteria'd field's
definition. Is this expected, and I'm just breaking a rule?

I can always expand the definition of the field I want to filter, so
that its definition contains only "table" fields, I guess. I'm already
doing some of the same math in another field returned by the query, though,
so it's redundant to do it that way, and that just doesn't digest well.

Can someone explain to me what is happening, and how I might best
deal with the situation?

Thanks,

Max
 
Yes, you need to repeat the entire expression in the WHERE clause (or in the
Filter expression) instead of referring to the calculated field by name.
 
Back
Top