Pass thru query question

  • Thread starter Sarah at DaVita
  • Start date
S

Sarah at DaVita

I sql you can put in prompts using the & sign. I use these a lot to get data
from Oracle but they do not seem to work when used in a pass thru query. Is
there a way to use prompts in a pass thru query?
 
J

John W. Vinson

Is there a way to use prompts in a pass thru query?
Click to expand...

Only by reading the prompts from code (e.g. from a Form or an Inputbox
function call) and explicitly copying them into the SQL of the query. There is
no way for the database engine to which you are passing the query to see the
Access frontend prompt value.

John W. Vinson [MVP]
 
Top