This is a quick tip to show the use of the DISTINCT argument of the
Datawindow Count() function. If you have a result set like: Row 1: A
Row 2: A
Row 3: A
Row 4: B
Row 5: C
Row 6: C
The Count() of the rows would give you 6 but if you wanted the distinct number of
values for a column you could code: Count( X for all DISTINCT) where X is the
column you are interested in. |