Passing Parameters in Pass-Through query

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

Guest

I'm trying to create a sql pass through query in Access 2000 conecting to a
SQL Server database. How do I pass a date parameter to the pass-through
query? I've tried creating a custom function in Access but that didn't work.
 
Open the querydef using VBA, alter the SQL WHERE clause with the desired
parameters, and save the query. Execute the PTQ.
 
Back
Top