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.

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.

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