List box total count

[manisha_uit]

Hi,

How to display the total count of the values present in a particular list box?

Thanks

Manisha

[kaushiknsolanki]

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

[manisha_uit]

Hi,

I mean if i have 100 values in the list box it should show 100 like a statistic count.

Thanks

Manisha

[kaushiknsolanki]

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

[manisha_uit]

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

[kaushiknsolanki]

Hi,

   Ok.

   Go to the properties of the listbox -> in expression tab -> add expression -> count(Field)

Regards,

Kaushik Solanki

[SunilChauhan]

in caption of list box u can write expression folloing '=' sign.

thanks

Sunil Chauhan

[manisha_uit]

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

[kaushiknsolanki · Accepted solution]

Hi,

   In properties of the listbox -> General Tab -> In Title Type below statement.

   ='Grade               ' & count(Grade)

Regards,

Kaushik Solanki

[SunilChauhan]

see the attached file