calculated fields in query in secondary calculation

[Guest]

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?

 

[John Vinson]

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
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]