IF AND Statement

[Noah114]

Is there a statement in access similiar to the IF/AND statement in Excel? I need to know, if days is > 30 and qty = 4,

 

[PHV]

Have a look at the IIf function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

If days > 30 AND qty = 4 Then
   X = 99
Else
   X = 0
End If

or the Immediate If

X = IIf(days > 30 AND qty = 4, 99, 0)

 

[rjoubert]

Noah, are you writing an Access query? Or are you in VBA code (in a module or behind a form/report)?