linking tables where data-type is not equal

  • Thread starter Thread starter dd
  • Start date Start date
D

dd

I have two SQL-Link tables with only one field they can
link by (OID). One of the tables defines the datatype for
the field as Text while the other has it as a number. I
can't change the design of either table. In a query, how
can I link the two. so far, I have just been able to do a
make-Table query and change the datatype in the design
view of the created table. This is not very dynamic.
Thank you,

dd
 
I have two SQL-Link tables with only one field they can
link by (OID). One of the tables defines the datatype for
the field as Text while the other has it as a number. I
can't change the design of either table. In a query, how
can I link the two. so far, I have just been able to do a
make-Table query and change the datatype in the design
view of the created table. This is not very dynamic.
Thank you,

dd
Click to expand...

You can link the numeric field to Val([textfield]).

This will be ....slow.... and probably not updateable. Any chance you
could create a View in the SQL/Server instance?
 
Back
Top