(this is a continuation from the original post re; querying against Oracle linked tables - that part is fixed but I am now having an issue strictly on the Access side)
HI everyone! Back at this - what I ended up doing was making a table with the information I want from the Oracle table (ex: 10200300, 10200400, 3045X000, etc. ) Access created that as a MEMO field, and I just changed to text.
So I have an Access table with a text field with values such as "10002000", "V5003000", etc.
I also have a query that selects portions of the whole account field (eg characters 2-10 should match the values in the text filed in the table above). This query shows the account portion "V5003000" of the field.
So, now I can see that I have some accounts in the normal query that DO NOT appear in the table text field, BUT the unmatched query does not return any values!
Here is the SQL:
450qryPGL_GLAccount_GL LEFT JOIN ORP5_VALID_ACCOUNTS ON [450qryPGL_GLAccount_GL].[Acct] = ORP5_VALID_ACCOUNTS.[Account]
WHERE (((ORP5_VALID_ACCOUNTS.Account) Is Null));
Thanks in advance!