Query Parameters

[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

 

[vanderghast]

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