Question If Statement

[Steve_T]

Hello,
I have an issue with a If statement that i have wrote, it is looking at the system time which i have set using the correct format but i get the feeling i have other looked something very simple.
I would be gratfull if someone could have a look and feedback any suggestions.

If Me.txtTime >= #7:00:00 AM# <= #2:59:00 PM# Then
Me.Code = "A"
End If
If Me.txtTime >= #3:00:00 PM# <= #10:59:00 PM# Then
Me.Code = "B"
End If
If Me.txtTime >= #11:00:00 PM# <= #6:59:00 AM# Then
Me.Code = "C"
End If

 

[John Big Booty]

Try;

If Me.txtTime.Value >= #7:00:00 AM# And Me.txtTime.Value <= #2:59:00 PM# Then
Me.Code = "A"

ElseIf Me.txtTime.Value >= #3:00:00 PM# And Me.txtTime.Value <= #10:59:00 PM# Then
Me.Code = "B"

ElseIf Me.txtTime.Value >= #11:00:00 PM# And Me.txtTime.Value <= #11:59:00 PM# Then
Me.Code = "C"

ElseIf Me.txtTime.Value >= #12:00:00 AM# And Me.txtTime.Value <= #6:59:00 AM# Then
Me.Code = "C"
End If

You need to have a check either side of mid night to return a result for "C"

 

[pbaldy]

The proper syntax would be

If Me.txtTime >= #7:00:00 AM# AND Me.txtTime <= #2:59:00 PM# Then

 

[Steve_T]

Gents,
Thank you for your feedback and support in my problem, the code is now working correctly.