I am new to FMP7 and I am looking for a more elegant solution to the question below.

I have 3 variables with the values of a, b or c. I want to create a new variable that counts the number of times the value "c" occurs within a record.

I could create three new variables that issolate the "c" using the If and/or Case function and then create a variable that "counts" the number of "Cs" in the record but there must be a more effeicient way of doing this.

Also, is there a way to create mutiple new variables using scriptmaker so you don't have to "muscel" your way through the point and click menus, as you could using SPSS syntax?

Any help would be appreciated.

How is your database set up? These are fields you are referring to instead of variables?

P.S. Mod, can we move this to the appropriate forum?

Edited October 6, 200520 yr by Guest

Its a single data base (table) with around 500,000 records. Sorry for the language confusion. Variable = Field.

Sorry for putting this up in the wrong forum.