pass through query variable

G

Guest

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

Compare Records in the same table 4
Tricky query question 15
Pass-thru Queries 1
Variable in SQL Where Statement in “Pass Through†Query 10
Export query with passed criteria 6
Access pass-through query to Oracle 10g stored procedure - results 1
pass through query variables 8
Using Bind Variables in pass-thru query to Oracle DB. 1

Top