Expression count()

[#1]

Hello everyone!
I need help, I have a simple table object that displays me

Name	Usernane	Service	Months	hours
a1	pat	communication	1	10:30
a1	pat	communication	2	11:11
a1	pat	communication	1	09:00
b1	jul	communication	1	15:00
b1	jul	communication	1	05:45
c2	kou		12	07:30
bol	sal	communication	8	07:50

My problem is that want create another expression that counts the number of times the name appears.

sql I should have something like:

Select Count(*) from mychart GROUP BY (Name,Username,Months,Service)

[preminqlik]

hi PFa

[fred_s]

Hi Kouens,

See attachment.

- Show frequency in Listbox
- count(usernane) in table (Yes, usernane with N in your example)
- As textbox with Set analysis

[#4]

thank you, I love this expresion, I want to know how to retrieve the selected value without defining default

='no of Pats: ' & count( {<Usernane = {'pat'} >} Usernane)

[fred_s · Accepted solution]

Do you mean expressions like this..

[#6]

Thank you Fred