Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Do you mean expressions like this..
hi PFa
Hi Kouens,
See attachment.
- Show frequency in Listbox
- count(usernane) in table (Yes, usernane with N in your example)
- As textbox with Set analysis
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)
Do you mean expressions like this..
Thank you Fred