I have a subform that I enter string data into 5 fields per record. So for example, size, color, shape, texture, durability.
I would convert the data in each of the 5 fields into an integer that equals 1 only if it matches a particular entry using a series of if statements. So if the size is large then it gets a score of 1. If the color is red it gets a score of 1. If the shape is circular it gets a score of 1. If the texture is smooth it gets a score of 1. If the durability is high it gets a score of 1. Any other size, color, shape, texture or durability gets a score of 0. So I have made a series of if statements for this part.
I want the 6th field of the record to be a total score that calculates the sum of the scores for the first 5 fields and display it. I am having trouble displaying the sum of the scores in the last field. So I have the if statements in the script builder for "on user input" for the 6th field. I have a variable for the total scores. But I don't know how to get the last field to display this total score variable.