Pass Thru Query / Criteria

G

Guest

I am running an access append query that uses an Oracle Passthru query to
retrieve the records from our data warehouxe. It works beautifully but, I
have hardcoded the requested date into the criteria section of the pass thru
code (Oracle).

and dcc.dw_collateral_commitment_date = to_date('06/01/06','mm/dd/yy')

This query is run from VBA code and I want to pass a variable holding the
date instead of hard coding the date.

How can I do this?

Many Thanks

Ross
 
D

Duane Hookom

Modify the SQL property of the saved pass-through query with DAO code like:
CurrentDb.QueryDefs("qsptToOracle").SQL = "....And dcc.dw_....to_Date('" &
DateValue & "','mm/dd/yy')"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format with Pass Through and form fields 1
Pass Thru Times out 2
Incorrect date in pass-thru query 1
Using Bind Variables in pass-thru query to Oracle DB. 1
Pass Through Query Make Table 3
Date Parameter 8
Access pass-through query to Oracle 10g stored procedure - results 1
Filtering Criteria Question 2

Top