I am just a beginner. I know how to code in order to get a automated count of the rows but I am trying to go one step further.
I would like to be able to get a number that equate to the number of time that a value was picked from a drop down list.
I have attached a couple illustrations to explain what I am trying to achieve :
At the end I would like to end up with something like this.
Any assistance would be much appreciated.
To do something like this you need to use the calculate event of the count field.
What you want to do is to count how many times the name in the dropdown list is selected up to this row.
And in FormCalc :
Hope this help!
You were a great help again. It works exactly the way I was hoping for.