If Stataments in Queries 1

[Wrecker]

Can If statments be written in the criteria setion of a Query? I need to change the amount a number is multiplied by, depending on the text in a field. I know how to do it in a module for a form, but i'm not sure how to do it in a Query.

Thanks in Advance
Wrecker

 

[OldTom]

Hi Wrecker

You just need to use iif in a query

e.g.

iif([FieldA]="A",OldValue*Multiplier1,OldValue*Multiplier2)

Regards

Tom