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
 
Top