IIf AND

[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

 

[NBullock]

Try this

Expr1: IIf([RecTime] Between "1000" And "1200","Y",Null)

 

[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

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

 

[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