Converting data types

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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