query between dates and timeline

[blacknight74]

I need to do a query for data with criteria to enter between dates and between time. I manage to get the date criteria right. However when placing the criteria for time ig I query from 1900hrs to 0700hrs, only data from 0001 to 0700hrs appear. Any help please?

[ItsMe]

Why not include the date in your query between times?

[blacknight74]

Because the i need to query data for eg: from 15th to 30th of the month and only data from 19000hrs to 0700hrs
Thanks

[ItsMe]

Then you will need to assign a common date to your time. I use 1/1/1990, for instance. You can concatenate the literal text for the date part to the format function isolating the time portion.

I believe this would be correct for 24hr clock and SQL query. "1/1/1990 " & format([MyDateField], hhmmss)