BETWEEN from hours

[sal21]

Ho to use a between sql from 2 hours?

Attached my property filed.

In field ORA have:

11:20
15:17
...
12:26

i use Access database

[HansV]

You can use (for example)

SELECT ... FROM ... WHERE ORA_OP Between #05:00# And #14:00#

[sal21]

You can use (for example)

SELECT ... FROM ... WHERE ORA_OP Between #05:00# And #14:00#

WOW!

about this post....

i have a var MyVar=7 (is the initial hour of list)

i need to fill a combobox3 with hours and half hour from MyVar =7 to 24 with a step of half hour in this format HH:MM

similar:
07:00
07:30
08:00
08:30
...
24:00

MyVar is variable and it can assume only a fied hour 7 or 8 or 9...ecc

my test code, but not work:-(

Code: Select all

 Dim INIZIO As String
    INIZIO = 7
    With Me.Combo3
    For I = 0 To 24
    INIZIO = INIZIO + 30
    Me.Combo3.AddItem Format$(INIZIO, "HH:MM")
    DoEvents
    Next I
    End With

[HansV]

Try this:

Code: Select all

    Dim i As Long
    For i = 2 * MyVar To 48
        Me.Combo3.AddItem Format(i / 48, "hh:mm")
    Next i

[sal21]

You can use (for example)

SELECT ... FROM ... WHERE ORA_OP Between #05:00# And #14:00#

sorry me... but
If the two var INIZIO & FINE are = blank wath range of hours get the sql?

[HansV]

You'll get an error message.