Click to See Complete Forum and Search --> : [RESOLVED] Summing the number of groups?
Besoup
Aug 11th, 2006, 10:22 AM
Is there a way I can just sum that amount of groups in the report?
ducky
Aug 11th, 2006, 10:40 AM
Create a Running Total Field. The field to summarize should be the field you are grouping by and the type of summay should be count. The running total should be set to evaluate on change of the group and reset never. Place this running total in your report footer and youu'll see the total count of groups.
Besoup
Aug 11th, 2006, 10:54 AM
Not sure if I follow what you mean... how would I create a running total field?
using CR11 if that matters.
Besoup
Aug 11th, 2006, 10:55 AM
nvm go it using distinct count... thanks for the help.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.