Linking 2 tables by a value with different dattypes

[bugsy]

in one table id is a text, in other its a number.
what 's the best solution ?

If needed, i can have a query of a table rhere the value is numeric, and convert it to text.

something like

VAL(ID)

but the other way around

 

[raskew]

Hi-
Lookup the Str() function.

Bob

 

[neileg]

One problem with Str() is that it adds a leading space to positive numbers. If you don't want the space use CStr() instead.

 

[bugsy]

One problem with Str() is that it adds a leading space to positive numbers. If you don't want the space use CStr() instead.

guess i should have used CStr; STR - converted them to text, but I wan't able to link to my other table.

So i had to change the other table to use VAL (and thus getting integer value)