pass through query variable

M

mroby

Can I use a variable in the where clause of a pass through query?

Where Customer_Number = &CustNum
 
T

Tom Ellison

Dear Mroby:

Generate the SQL string in code, including the value in the variable,
using the rules for the server to which you want to pass the query.
Use the proper methods in DAO of ADO to pass the query.



Can I use a variable in the where clause of a pass through query?

Where Customer_Number = &CustNum
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 

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

How to create a bubble chart with more than 2 variables. 0
Record AFTER latest by date an time, grouped by serial number 6
Password protect new workbooks from template 0
Passing a variable to a query 1
Variable in SQL Where Statement in “Pass Through†Query 12
pass through query variables 8
Access pass-through query to Oracle 10g stored procedure - results 1
Export query with passed criteria 6

Top