Unmatch Query with Dates - Bad Results

[The_Vincester]

I've got an unmatched query set up that works pretty well using a linked Excel file, and an Access Table. It compares a Name, Day of the Week, Start Time and End Time.

The problem is that some that I KNOW are matching are turning up as unmatched. It typically seems to happen when it's an "odd" time, with and End Time like 10:20 PM or 9:40 AM.

I suspect this may be because Excel actually sees dates as decimals and the way Access is interpreting that time is different and it sees it as not matching.

I need these "stored" as times, so I can't change the values to text, where I think they would match.

Does anyone have any suggestions?

 

[RuralGuy]

Maybe this link will help understand how Access stores DateTime fields. I suspect you could coerce the two fields into a similar format to make the compare without changing the original field.