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