|
Couning Distinct Values -- Vic --
I'm trying to count distinct group numbers. The data is already in the table. I just need to count the distinct groupnumbers in the table. Is my syntax correct? here is the code that I'm using: Dim lnumgrp As Int64 lnumgrp = oWS.WSDataSet.Tables("Worksheet").Compute("Count Distinct(GroupNumber)", "Exclude=false") If the syntax is not correct, could anybody give some suggestions on how I can do this? |