Time equality not being detected

[Tesita]

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!!!

[jim mcnamara]

Time is not stored as "7:40PM", it is usually a longword that holds the number of milleseconds since midnight.

You have to "bracket the value"

where format(appt_time,"HH:MM") > "19:39" and
        format(appt_time,"HH:MM") < "19:41"