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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Max Moor" <maxmoor@remove_hotmail.com> wrote in message
news:Xns95C71A8B9B05maxmoorhotmailcom@207.46.248.16...
> 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