calculated fields in query in secondary calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
Click to expand...
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?
 
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?
Click to expand...

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