How do I query on accounts in a specific city?

There may be times when you want to query on donors who live in a specific city. For example, I want to query on those constituents who live within Los Angeles.
Here are the steps to query on accounts who live in a specific city: 
  1. Click Queries
  2. Select a category that you want to store this query in (Example: Base)
  3. Select New Query under the tasks menu
  4. Name the query All Constituents who live in Los Angeles 
  5. Set the Starting Query to Category: Base and Query: All Constituents
  6. Set the Data Return Type to Accounts
  7. Beneath Criteria > Browse Fields choose Account from the drop down box
  8. Click City
  9. Type in Los AngelesUser-added image
  10. Click Save and Preview



Was this article helpful?