Jul 06 2007
How many values were picked from a list?
The Challenge
It is not uncommon for a report writer to want to know how many items were selected from a prompt. The challenge is that there really isn’t a way to do that, at least not one that is available as a function. So this article will show an interesting way to solve that challenge. It is not my original idea; it came from a post on BOB. At the moment I cannot find the post in order to give credit to the original author.
In a nutshell what is required is as follows:
- Capture the user’s response to the prompt
- Count the number of semi-colon characters found in that string