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.
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.