count of values displayed in a list box

[sonikajain]

Hi all,

A list box displays distinct vales of a column. Please hlep me in displaying the count of values in a list boxfrom the UI.

[Miguel_Angel_Baeyens]

Hi,

Go to the listbox properties, and check "Show Frequency" in the General tab.

Hope that helps.

Miguel

[sonikajain]

Thanks...its giving me the no of items displyed...how can I achieve the same in a table.....

[Jason_Michaelides]

Count(Field) as an expression.

[#5]

Hi everyone,

since i just experienced this problem:

What I'm gonna do if "Show Frequency" is greyed and therefore not checkable (list box is read only)? Is there a workaround?

Yes, here you are:

You can type in the General tab of the list box as title:

     ='what ever you want to count: ' & COUNT(DISTINCT <fieldname>)

Regards