I have a list of 30 cities, and I want to get the number of "homes" in each city. In a single query like "homes in Fresno", WA will interpret "homes" as "number of owner-occupied housing units" and return a result. My list is in "City, ST" format. I tried creating a list and it seems to properly have 30 items in it. How do I combine this list with a query as in above? I tried entering the list, then adding "number of homes" and other combinations, but can't get anything to work. Am I misunderstanding how lists work with queries?
Thanks for any help!
Thanks, but I'm not sure how this helps me. I have a list of 30 cities. How do I make a list of these, and then get the "number of owner-occupied housing units" for all 30?