tomnich
asked on
Using parameters in SQL passthrough query
I'm using Access 97 and usign a SQL pass through query to pass a paramter - works fine in normal access query, but not in a sql passthrough query. [Office] is the parameter in the where clause of a select query, which is used by an Access INSERT query
WHERE substring(tblCurrencySerie s.Currency Code,1,2) = [Office]
Doesn't seem to work and it doesn't allow me to set the value of the parameter in code
WHERE substring(tblCurrencySerie
Doesn't seem to work and it doesn't allow me to set the value of the parameter in code
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.