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.