Filter Calculated Query Field

[Jaye7]

So I have the following query field which calculates another field.

How do I Filter the records in this calculated field to only return TRUE, as if I put "TRUE" in the Criteria for this field (or anything at all) then a parameter message box pops up asking for [Balance].

Balance1: IIf([Balance]<>0,"TRUE","FALSE")

 

[llkhoutx]

Tha means tat "Balance" is not a (bound) column in your query.

 

[Jaye7]

No, balance is a calculated field

 

[llkhoutx]

Filter the calculation, not the resultant column name. To filter the [Calculation], filter the query where [Calculation] is calculated.

 

[Jaye7]

Tried that also and same result, it still shows 0 values.

 

[llkhoutx]

You can't use a calculated field in a new column in a query in which the calculated field is defined.

 

[Jaye7]

OK, thanks for your help, much appreciated

 

[spikepl]

Do yourself a favour and actually read what I wrote about comparing Single/double variables as the last post on your previous thread on this subject.

 

[Jaye7]

I did read that, thanks Spikepl