SQL Date/Time

I have an Access database that is linked to an SQL Server Database by ODBC and if I do a WHERE with a field that is time it never gives me any records, Any idea why?
Who is Participating?
celticsConnect With a Mentor Commented:
Here is the solution as provided by Microsoft :
All Courses

From novice to tech pro — start learning today.