Using parameters in Pass_Through queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a lenghty and complex SQL query that I am attempting to run in Access
as a pass through query. The query runs fine, however I want to prompt users
to enter certain parameters (such as a date). Can this be done, and if so,
how?
 
I have a lenghty and complex SQL query that I am attempting to run in Access
as a pass through query. The query runs fine, however I want to prompt users
to enter certain parameters (such as a date). Can this be done, and if so,
how?
Click to expand...

Alas, only by constructing the SQL string in code, including the
parameter values as literals.

John W. Vinson[MVP]
 
I was afraid of that. Thanks John!

John Vinson said:
Alas, only by constructing the SQL string in code, including the
parameter values as literals.

John W. Vinson[MVP]
Click to expand...
 
Back
Top