SELECT * FROM MyTable WHERE TTOC(DateTime, 2) BETWEEN "12:00:00" AND "14:00:00"

HTH

>I have a datetime field in my VFP3 table. I want to COUNT all the records for my datetime field between a specified TIME regardless of the date.
>
>I want to find the busy times of the day for my system and use all the data in my system, not just one days worth of info.