How to display the total count of the values present in a particular list box?
Do you mean to say if you have 100 values in listbox you want to show 100.
Or do you mean that you have 100 values which are repeated in listbox and you want to know which value is repeated how many times.
I mean if i have 100 values in the list box it should show 100 like a statistic count.
Create a textbox.
In text area type
Here field name is the one for which you have created the list box.
But how to get the count on the same list box.
Like on the left side i have field name and the count on the right side.
Go to the properties of the listbox -> in expression tab -> add expression -> count(Field)
Thanks for your reply. But what you suggested gives me the following result.
Instead i want to display something like:
Please look into this.
In properties of the listbox -> General Tab -> In Title Type below statement.
='Grade ' & count(Grade)
Thanks a lot.
see the attached file
in caption of list box u can write expression folloing '=' sign.
how do I see how many times the data is repeated in the list box?
Put the listbox with the desired field and check the option under General Tab i.e Show Frequency.
Here is frequency shows the numbers of time the data appeared in table.
Retrieving data ...