S
Secret Squirrel
I'm looking to count the # of records for each of my 2 groups on my report. I
have 2 groups, "Quality", and "Documentation". What I want to do is have 2
controls on my report footer that will count the number of records for each
of these groups. One control will give me a count total for "Quality" and the
other will give me the count total for "Documentation". This is what I'm
using but it's counting all records:
TextControl1 =Abs(Count([VendorID]*([Type]="Documentation")))
TextControl2 =Abs(Count([VendorID]*([Type]="Quality")))
How do I set this up so that each of the above controls will only count the
records for that specific group?
have 2 groups, "Quality", and "Documentation". What I want to do is have 2
controls on my report footer that will count the number of records for each
of these groups. One control will give me a count total for "Quality" and the
other will give me the count total for "Documentation". This is what I'm
using but it's counting all records:
TextControl1 =Abs(Count([VendorID]*([Type]="Documentation")))
TextControl2 =Abs(Count([VendorID]*([Type]="Quality")))
How do I set this up so that each of the above controls will only count the
records for that specific group?