I am trying to do a simple query between two tables which come from an
ODBC (oracle) database, so I cannot change the data type of these
values.
I am trying to do a join between a field (REFERENCE_2) which stores an
Invoice ID as a text string and the Invoice ID in the Invoices table
which of course is a number data type.
is there any way I can modify this query so that I can make this join
happen without getting the following error "Type mismatch in
expression".
In Oracle we can do this query and oracle does not have this
limitation - it can query between fields of different data types.
Note I do not know VB - I can only use SQL.
Thanks for your help - I am really stuck with this one.