I defined a table with several datetime fields. I populated the StartTime column with eg. 10:00 (no date value). When I try to use the query:<BR>Select * from appointments where StartTime > #10:00:00# I get a data type mismatch error. I also tried ' 10:00:00' #10:00# #04/19/2000 10:00# all with te same results. Selecting without a where clause gives a correct result. Any clues?