Convert to string/varchar?

K

KatMagic

I have a table with a ContactID field. This ContactID field references 2
tables in another database, one of the tables uses an integer field and one
uses a uniqueidentifier as the primary key. In SQL, I would query the
database something like the following; How can I do this in Access:

Select * from xrContactList
inner join ContactTable1 on Convert(varchar(50),
xrContactList.Contactid)=Convert(varchar(50), ContactTable1.id)
inner join ContactTable2 on Convert(varchar(50),
xrContactList.Contactid)=Convert(varchar(50), ContactTable2.id


I cannot find an equivalent to the "Convert" function to make Access treat
both id's as strings. Thank you for your help.
 
Top