Table List as a Query Criteria as "OR"

[JTBrown1689]

I have a Table that uses a Lookup to identify the different MembershipTypes. My queries are all base one or multiple values of that Lookup.
My current query set of criteria, examples as follows: 1, 1 or 2, >4, 1 or 2 or 3 or 7.


My issue is that if I add a new item to the Lookup, I have to update the Query to ensure it is included. I know I can use a table item in the criteria, but being a numeric field, my attempts to include the "or" is text and I am receiving a "Type Mismatch in Expression" which I understand as Text versus Numeric.
Any help or ideas to try would be appreciated.

[June7]

I know I can use a table item in the criteria, but being a numeric field, my attempts to include the "or" is text and I am receiving a "Type Mismatch in Expression" which I understand as Text versus Numeric.

I don't follow how you "include" the or operator and get this error.

Provide your SQL for analysis. You can even provide db - follow instructions at bottom of my post.

I prefer to use VBA to build filter criteria and apply to form or report. Review: http://allenbrowne.com/ser-62.html

[Welshgasman]

For other than the >4 criteria, you could use IN().