Pass Thru Query / Criteria

R

Ross

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

Issue with OLE DB Query - Date Search 0
Using Bind Variables in pass-thru query to Oracle DB. 1
Incorrect date in pass-thru query 1
Date Format with Pass Through and form fields 2
Pass Thru Query Data Parameter Syntax 0
Access pass-through query to Oracle 10g stored procedure - results 1
Pass Through Query Make Table 3
Dlookup 7

Top