IIf AND

G

Gringarlow

I want to determine if a field is between two values.
If RecTime is between 1000 and 1200, return Y, otherwire return blank.
Thank You
 
F

fredg

I want to determine if a field is between two values.
If RecTime is between 1000 and 1200, return Y, otherwire return blank.
Thank You
Click to expand...

Exp:IIf([RecTime]>=1000 and [RecTime]<=1200,"Y","")
 
J

John Spencer

Use the following expression.
Assumption: Rectime is a datetime field.

IIF(RecTime Between #10:00:00# and #12:00:00#,"Y",Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Top