relate Long Integer with Text

S

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
 
C

Chris2

Song Su said:
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
Click to expand...

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