I have a table of bookings in my database. I have a query that takes a time entered by the user and checks whether there is a booking for that time. Although the time entered by the user is 7:40am and the time in the table is 7:40am when my sql statement is run it says there are no records, i.e. recordcount=0.

I have been trying to make this work for a week now with no success. What am I doing wrong? I have even tried formatting the time field but it still doesn't work.

HELP!!!