oxicottin's latest activity
-
oxicottin replied to the thread Solved Check SQL for number.Thanks your suggestions worked... -
Hello I have a SQL that gives either a null or a number and I want to use it to determine opening a form. If the strSQL is null then...
-
I cant get a correct result in my query. I have a field (DelayHours) and I don't want to display anything that's in the range of 9.75 to...
-
oxicottin replied to the thread Solved Get date based on times.Sorry for the delay I been off.... Last two posts worked thanks....
-
Public Function getDate(DelayStart As Variant) Dim t As Variant If IsNull(DelayStart) Then Exit Function t = TimeValue(DelayStart)...
-
I just tested it... I forgot to add brackets. Try it this way: DateValue(DelayStart)+(TimeValue(DelayStart)<#3:00#)
-
oxicottin replied to the thread Solved Get date based on times.I get 0 I change post to fix... Also "DelayStart" is a Date/Time
-
oxicottin replied to the thread Solved Get date based on times.Typo it was a n....
-
I'm trying to write a function for military time to get the short date of a date/time based on the time of the day for the shift that...
