pass through query variable

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

Guest

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

Where Customer_Number = &CustNum
 
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
 
Back
Top