Search By Time

[TimTDP]

I have the table "tblTempTrainingDateTime"
It contains the fields:
TrainingTimeId - AutoNumber
TrainingTime - Date/Time & Format = Short Time

I have a record where the TrainingTime = 10:00:00

Why does the following return a null value?
lngTrainingTimeId = DLookup("TrainingTimeId", "tblTempTrainingDateTime", "TrainingTime = #10:00:00#")

Thanks in advance

 

[Ranman256]

the field is not just time, it is date/time.

I usu put the table in a query, all fields, and add either date only or time only:
TimeOnly: Format([TrainingTime],"hh:nn:ss")

then youj can query only time:
= DLookup("TrainingTimeId", "qsTempTrainingDateTime", "TimeOnly= #10:00:00#")

 

[Gasman]

Use the Time value function to compare just time?

 

[arnelgp]

the Format is for display purpose only.
it is still saving the Date portion (but not obvious).

lngTrainingTimeId = DLookup("TrainingTimeId", "tblTempTrainingDateTime", "TimeValue(TrainingTime) = #10:00:00#")

 

[TimTDP]

Thanks so much
Didn't know about function "TimeValue"

Thanks

 

[Gasman]

Thanks so much
Didn't know about function "TimeValue"

Thanks

There is also a DateValue function when you want the date portion?