MS-Access -> ODBC -> Oracle Parameters

From: Joe R Jurgena <jjurgena_at_shell.clark.net>
Date: 22 Sep 1998 16:21:21 GMT
Message-ID: <6u8iq1$4l0$1@clarknet.clark.net>

I am using MS-Access 97 to connect to an Oracle Database with the Oracle 73 ODBC driver. How do you use replaceable parameters when using pass through queries. For example a begining and ending date for a query like:

SELECT
   paid_dt,
   sum(paid_amt)
FROM
   mytable
WHERE
   paid_dt between &beg_dt and &end_dt
GROUP BY
   paid_dt;

The user would run the query, get prompted for the two dates, the query would be passed to Oracle and the result table would return to Access.

The table is too big to be accessed as a linked table.

Thanks
Joe Received on Tue Sep 22 1998 - 11:21:21 CDT