I am new to Oracle. I am trying to create a query in MS Access on linked oracle tables that use a date range like this:
Between FormatDateTime(Now()) And FormatDateTime(DateAdd("yyyy",-2,Now()))
This works as long as I dont connect any other tables and add other parameters in other attached fields.
It took me quite some time to figure out the function above as I understood that oracle handles dates differently.
I need to be able to query oracle tables from MS Access and use dynamic date ranges (as above) and then add parameters to other feilds in linked tables.
What have I missed.
Thanks in advance.