Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
expression showing a count
So how do you make the expression only count the null values of each particular group?, I want it to continue to count all groups over the whole report but unfortunately in my test it continuously counts, i.e. if the first group has 3 values and the second group has 7 it counts 3 for the first...- cat02
- Post #11
- Forum: Microsoft: Access Reports
-
expression showing a count
Interested in how you solved this problem. I can see how =count(composer) might work, but did it? Or did it continue to add the composers so that for Bach you got 13 counts of work instead of 12 and so on? Did you solve the second question? Did Duane's =Abs(Sum([Composer]="Bach") )...- cat02
- Post #9
- Forum: Microsoft: Access Reports
