>Try CStr() function, I am almost sure that this function returns Date in some format as string but not exactly as DTOS()
>

>select * from Visits inner join Doctors where patient_name + CStr(date) in (select patient_name + CStr(date) from ...
>

>I'll keep digging :-)

I could not find cStr function in HELP. Typing cStr doesn't bring anything. Same for the format function. I had the same recollection about cStr.