calculated fields in query in secondary calculation

I have a query that calculates two fields (YTD Budget and YTD Actual). I
have a secondary calculation named "Variance" within the query that takes
these two fields and subtracts them to get a variance. This works fine until
I add criteria to the "Variance" field, asking to only return variances
$50,000. Once I add the criteria, I then get a box looking for what YTD
Budget equals and then what YTD Actual equals (it's ignoring the primary
calculation I have in each of these fields). Any ideas on what I might be
doing wrong?

On Mon, 11 Apr 2005 18:27:02 -0700, pruaccess
wrote:

I have a query that calculates two fields (YTD Budget and YTD Actual). I
have a secondary calculation named "Variance" within the query that takes
these two fields and subtracts them to get a variance. This works fine until
I add criteria to the "Variance" field, asking to only return variances
$50,000. Once I add the criteria, I then get a box looking for what YTD
Budget equals and then what YTD Actual equals (it's ignoring the primary
calculation I have in each of these fields). Any ideas on what I might be
doing wrong?

Just trying to reuse a calculated field in a further calculation. No
can do!

Either base a second query on the first query, or recapitulate the
expression for [YTD Budget] and [YTD Actual] in the expression for
Variance.

John W. Vinson[MVP]