Iif Statement in query

[evanhughes]

Hi All

I have a query to which I need to add a charge.
The query is based on table1 but the charge is only added if a yes/no field in table2 is true.

This is what I have tried but it does not work.

Charge: IIf([Table2]![Field1]=True,Format("25","Currency"),Format("0","Currency "))

Any ideas on what I am doing wrong.

I tried adding table2 to the query and it just upset everything.

Evan

[RedWolf3x]

This may be an easy fix,

If the [Table2]![Field1]=True is a boolean value, change true to -1

Hope this helps.

-Red