Hi,

I'm trying to "connect" two fields of the diferent types, one of them is STRING, and the other is DATE.

SELECT firstName, lastName
FROM tblPerson, tblPerson1
WHERE tblPerson.Date = tblPerson1.Date
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AND tblPerson.Date LIKE '7.4.2003'

tblPerson.Date is STRING type field
tblPerson1.Date is DATE type field

I've tried using in my ASP code:
WHERE tblPerson.Date = CStr(tblPerson1.Date)

but when I execute the query, the recordset is empty.
The thing is, when I try the same query in MS Access query editor, it works !?!?

Please help, Neven

I'm no expert on field type issues, but since you say it works fine in MSAccess, I would try:

WHERE CStr(tblPerson.Date) = CStr(tblPerson1.Date)

or CDate(tblPerson.Date) = tblPerson1.Date


Tim

you could be having a problem where you

are trying to join where '3/13/2003' = '3/13/2003 6:00am' and it isnt matching.