Invalid data in report

[Guest]

Hello all,

I have an expresion in a query that I want to be an numberic value. So that
when I run the report it will not allow me to sum it.

Query Expresion
Low: IIf([variance]<"0",[variance],"0")

Report
=sum([Low])

I get invalid data type error message

 

[Allen Browne]

Drop the quotes:
Low: IIf([variance] < 0,[variance], 0)

When you put a value in quotes, JET treats it as a text (string) value, and
it cannot be summed.

For further suggestions on how to help JET understand your intended data
type, see:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html