if and statement

[tubar]

I have scratched my head on this for awhile...if the time out is 2:30pm it shows "18" if its 1am it shows "0" however 2am, 3am, 4am are all good...

If Me.Time_Out.Value >= ("12:00am") And Me.Time_Out.Value <= ("5:00am") Then
Me.appy_hours.Value = DateDiff("h", [Time_in], "12:00AM") + 24
Else
Me.appy_hours.Value = 0
End If

 

[jdraw]

Date/Time values need # surrounding the values,
" indicates a string.
Datediff uses date values

see http://www.techonthenet.com/access/functions/date/datediff.php