Parameters for SQL Pass Thru

[JimWho]

I have an Oracle SQL that is sent from Access through an SQL Pass Thru. In this SQL my WHERE statement has a date field which I must change to a certain date. Is there any way that I can set this up as a parameter so that when I run the query it asks for the date before sending the SQL through the passthru to my Oracle database?

 

[mpastore]

Your pass thru query should just be select * from mytb

Then create a regular ms access query and use the pass through query as the source. You can then set the parameter in the ms access query. Use the ms access query from then on.

Mike