How to find accounts within a range of postal codes

At times, you may want to query on a group of Postal Codes in a certain range of numbers. For instance, you may want to query and report on all postal codes from 46000 to 47999. 
You are able to accomplish this task by utilizing the Postal Code Range query search field as shown in the steps below:
  1. Click Queries
  2. Select a category that you want to store this query in
  3. Select New Query under the tasks menu
  4. Name the query Accounts based on Postal Code Range
  5. Set the Starting criteria to Base/All Constituents
  6. Set the Data Return Type to Accounts
  7. Under Criteria Matching select Match Each Criteria
  8. Select Account from the Available Fields drop down menu and click on Postal Code Range
  9. Fill in the Starting Postal code (lower number) and the Ending Postal Code (the Higher Number)
  10. Click Save and View Queries

Environment

 eTapestry

Was this article helpful?