search on calculated field
I've just jumped up from FM 6 to 11 and need to come up with a way to count instances of zipcodes for large mailings.
I know how many customers are in a particular zip code but want find zips with greater than x customers. I can all the zip codes with the number of records, but can't figure out how to search and get a list of only those with more than 5 records or less than 14 in a given zip code. The calculated field is grayed out for finds. (they are all not indexed).
If I can figure that out, I can also get the first 3 zip digits sorted and sifted as I need.
mac intel, 10.6x
Any help appreciated.