I am looking to write a report that filters on zip code ranges. For example, I want a report for all Contacts in Southern California, and another for all contacts in Northern California. I know the start and end zip codes, but apparently "Billing Code" in non-numeric. Yet if I run a report, include the Billing Code field, and then sort on the columnar output, it sorts properly. So how do I filter?
I have this filter criteria:
| ( ( 1 and ( 2 and 3 ) ) or ( 4 and 5 ) ) |
Where 2 and 4 are start zip codes, and 3 and 5 are end.