Between If Statement

DS · Sep 10, 2006

I can't quie get the synatax for a between statement.
Any help appreciated.
Thanks
DS

If Me.D34 is between 29 and 31 Then
Me.TxtDay = Me.D34
Me.TxtDate = Me.TxtMonth & "/" & Me.TxtDay & "/" & Me.TxtYear
Else:
Me.TxtDate = ""
End If

Tom Lake · Sep 10, 2006

I'd do this:

If Me!D34 >= 29 And Me!D34 <= 31 Then
Me!TxtDay = Me!D34
Me!TxtDate = Me!TxtMonth & "/" & Me!TxtDay & "/" & Me!TxtYear
Else
Me!TxtDate = ""
End If

Tom Lake

J. Goddard · Sep 10, 2006

"Between" is only used in SQL.

John

DS · Sep 11, 2006

J. Goddard said:
"Between" is only used in SQL.

John

OK. So how can I phrase this?
Thanks
DS

J. Goddard · Sep 11, 2006

The post from Tom Lake shows the proper if statement:

If Me!D34 >= 29 And Me!D34 <= 31 Then
Me!TxtDay = Me!D34
Me!TxtDate = Me!TxtMonth & "/" & Me!TxtDay & "/" & Me!TxtYear
Else
Me!TxtDate = ""
End If

John

DS · Sep 11, 2006

J. Goddard said:
The post from Tom Lake shows the proper if statement:

If Me!D34 >= 29 And Me!D34 <= 31 Then
Me!TxtDay = Me!D34
Me!TxtDate = Me!TxtMonth & "/" & Me!TxtDay & "/" & Me!TxtYear
Else
Me!TxtDate = ""
End If

John

Thank you that worked perfectly!
DS