Time filter in query (1 Viewer)

[accessonly11]

dear access users,

I can filter date by using this expression on date field
Between [Forms]![ShiftReportF]![StartDate] And [Forms]![ShiftReportF]![EndDate]+1

but what express is to used to filter time, i already extracted time using timevalue.

 

[arnelgp]

you can use the same with your time field:

TimeValue([TimeField]) Between TimeValue([Forms]![ShiftReportF]![StartTime]) And TimeValue([Forms]![ShiftReportF]![EndTime])

 

[accessonly11]

i put this expression in query grid,

but facing this error

 

[theDBguy]

i put this expression in query grid,
View attachment 105666

but facing this error

View attachment 105667

Did you want to filter by date and time or just time?

 

[arnelgp]

you may try adding two "hidden" textbox to your form that retrieve the TimeValue of [StartTime] and [EndTime]
eg: (txtStartTime)
ControlSource: = TimeValue([StartTime])

(txtEndTime)
ControlSource: = TimeValue([EndTime])

now on your query use these hidden txtbox as criteria:

Between [Forms]![ShiftReportF]![txtStartTime] And [Forms]![ShiftReportF]![txtEndTime]