Less than Equal to?

K

K

Good day how would I code this?

If WALL is Equal to or greater than 0.065 and is equal to or less than
0.125 then PERCENTOD = .17

Your help is appreciated.
Thanks.
 
D

Dirk Goldgar

K said:
Good day how would I code this?

If WALL is Equal to or greater than 0.065 and is equal to or less than
0.125 then PERCENTOD = .17
Click to expand...


If WALL >= 0.065 And WALL <= 0.125 Then
PERCENTOD = .17
End If
 
K

KARL DEWEY

Or in a query design grid --
PERCENTOD: IIf([WALL] >= 0.065 And [WALL] <= 0.125, .17, "Unknown")
 
Top