Converting data types

[Andrew]

Hi, I'm looking for some help.

I have a query that links two tables together, both tables
are coming from different dbs. The linking field from each
table has different data types(string,numeric), Without
changing the data types of the table, is there a way I can
convert the data type of the field to run the query?

Thanks,
Andy

 

[Andre]

You can use conversion functions.

Instead of creating a join on the fields, in criteria use
a function. Right-click on the field and choose Build...