Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to display the total count of the values present in a particular list box?
Thanks
Manisha
Hi,
In properties of the listbox -> General Tab -> In Title Type below statement.
='Grade ' & count(Grade)
Regards,
Kaushik Solanki
Hi,
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.
Regards,
Kaushik Solanki
Hi,
I mean if i have 100 values in the list box it should show 100 like a statistic count.
Thanks
Manisha
Hi,
Create a textbox.
In text area type
=count(Filedname)
Here field name is the one for which you have created the list box.
Regards,
Kaushik Solanki
Hi,
Thats fine.
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.
Thanks
Manisha
Hi,
Ok.
Go to the properties of the listbox -> in expression tab -> add expression -> count(Field)
Regards,
Kaushik Solanki
in caption of list box u can write expression folloing '=' sign.
thanks
Sunil Chauhan
Hi Kaushik,
Thanks for your reply. But what you suggested gives me the following result.
Instead i want to display something like:
Please look into this.
Thanks
Manisha
Hi,
In properties of the listbox -> General Tab -> In Title Type below statement.
='Grade ' & count(Grade)
Regards,
Kaushik Solanki
see the attached file