AnsweredAssumed Answered

inserting values in field by find

Question asked by MichaelCoslo on May 28, 2014
Latest reply on Jun 2, 2014 by philmodjunk

Title

inserting values in field by find

Post

     Bit of a noob alert here.

     I have a FM database in which one of the fields contains county information. It consists of three letter abbreviations for any particular county. Typical would be CEN for "Center" County.

     What I want to do is to have a script search for the counties in that field, then if that particular value is found, to cause the value of another field to equal 1. If not found, the related field is 0. Then after the search for all of the counties is complete, the total number of counties is added from the related fields, then summed.

     In this case, there would be around 70 finds.

      

Outcomes