Time From Datetime

Hi! This is my first question here.

I want to make query where I want to show data only from time1 to time2 (for a month).

I want to make this in Access because I need Forms.

I made this on the SQL Server but I had to change the time limits in the code what I don't like. How to make this in Access SQL?

On the SQL server it looked like this:

SELECT * FROM TimeSample
WHERE TimeVal - CAST(FLOOR(CAST(TimeVal AS float)) AS datetime) > '10:00' AND
TimeVal - CAST(FLOOR(CAST(TimeVal AS float)) AS datetime) < '17:00'

Any ideas?

Thanks, Bob.