AnsweredAssumed Answered

search on calculated field

Question asked by jayGamel on May 13, 2011
Latest reply on May 13, 2011 by LaRetta_1


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.