Operators in Parameter Queries

[Jodi_MHS]

I am trying to set up parameter queries so that I can eventually get macros running. The problem I have is that I need to have Operators in the parameter criteria. Does any one know how to use ranges in parameter queries with operators? For example: Between 1 and 5. For example: Is null or > 12/31/01.

 

[Pat Hartman]

You cannot pass relational operators to a query as a parameter. You can ONLY pass data values. You will need to build the queries in code.

 

[Jodi_MHS]

Thanks! You saved me a lot of time trying to figure out how to do it as a parameter.