relate Long Integer with Text

[Song Su]

How to relate field as Long Integer in one table with another filed as Text
in another table?

Two tables are from different database and I cannot change field type by
modifying table.

Thanks

 

[Chris2]

How to relate field as Long Integer in one table with another filed as Text
in another table?

Two tables are from different database and I cannot change field type by
modifying table.

Thanks

Song Su,


SELECT YT1.YourColumn_Integer
,YT2.YourColumn_Text
FROM YourTable_First AS YT1
INNER JOIN
YourTable_Second AS YT2
ON YT1.YourColumn_Integer = CInt(YT2.YourColumn_Text)


This assumes that the string values in YourColumn_Text actually
convert to an integer, and then that those converted integers are also
found in YourColumn_Integer.


Sincerely,

Chris O.