Criteria on field calculated form another calculated field

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top