I have 2 tables that I am connecting together in my MS Access 2013 query which runs by way of ODBC for Oracle,
In the query I need to link 2 tables
Below is the statement I am having trouble with:
from v_sfs_txn v left outer join ALFS_JOURNAL_VOUCHER ajv
In the query document_num is connected to journal_voucher_number
The problem occurs when I try to run the query because the field document_num is a SHORT TEST field
and the journal_voucher_number is a number,
I get an error message "Type mismatch in expression" and the query will not run.
There is no problem when this is run from Toad in Oracle.
Question: How can I convert the field "Document_num" from short text to a numeric value in the query so that the query will run from MS Access.
Thank you for your asistance.