Link to home
Start Free TrialLog in
Avatar of developingprogrammer
developingprogrammer

asked on

how to count group by field's total unique records by QBE

hi guys, this is a super simple question yall probably take like 5 seconds to answer. i've got everything explained + data in the excel file. thanks!!

edit --> for convenience:
question - why doesn't setting Totals to "Count" count the grouped by records for the CIN field?

i'm thinking the only way to do it is a sum(count(CIN)).

ah i think i need to do a query in a query right?

but still don't understsand why setting Totals to Count doesn't just give me the count of the grouped by row. could someone explain to me? thanks!!
Question.xls
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of developingprogrammer
developingprogrammer

ASKER

great! as always als315, thanks so much!! = ))