>>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.
Just try it :-) It is in VB help for Office applications. Access HELP is everithing but helpful :o)
Put
MsgBox CStr$(Date) in some module and see if it runs.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.