Conditional Statement using And / or

[Leesha]

Hi,
I have a query that needs to look for two criteria in order to post back the correct answer. The following sql keeps coming back stating "error". Is is even possible to do this?

Thanks,
Leesha

GreaseTrap1: IIf([contractversion]=1 And [store type]="SUP",True)

[HansV]

You omitted the 3rd argument, it is required. This should work:

GreaseTrap1: IIf([contractversion]=1 And [store type]="SUP",True,False)

but the following has the same effect and is shorter:

GreaseTrap1: [contractversion]=1 And [store type]="SUP"

[Leesha]

Perfect! Thanks!