Less than Equal to?

  • Thread starter Thread starter K
  • Start date Start date
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.
 
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
 
Or in a query design grid --
PERCENTOD: IIf([WALL] >= 0.065 And [WALL] <= 0.125, .17, "Unknown")
 
Back
Top