Query Parameters

  • Thread starter Thread starter Zeids
  • Start date Start date
Z

Zeids

I don't want to write SQL code and wanted to utilize the Paramater
definitions in queries.

I've been looking for a way to do something like:

querydef.parameters ("paramName") = "x" or "Y"

all I have found is assigning one value to to the parameter and I want to
use "and" / "or"... etc

Thanks
 
Can't with that level of execution.


With:


querydef.parameters ("paramName") = 3+4


it will send 7 as value for the parameter. It is obvious, right?



Now, changing + into AND , or into OR , or whatever operator, it won't
change the behavior of the compiler and its interaction with the SQL
statement.




I you expose your INITIAL problem, rather than the SOLUTION you have come
to, maybe someone would point you a simple elegant way to solve the initial
problem, rather than the problem of the problem of the problem... :-)



Vanderghast, Access MVP
 
Back
Top