Counting Report Fields

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

OK, I've searched the groups and probably looked at a few examples here and
there, but just can't seem to find the right answer. I have a report built
from a query that will print out a listing, grouped by SHOPS. Within each
SHOPS group, there is a column called TSC. The column can have a either a
"B", "C", "F", or a "G" in it. The customer wants the report to display at
the end of each SHOPS group a total of the TSC column. Not just a count of
records, but the number of each "B", "C", "F", and "G" records. Then, the
customer wants to add together the "B" and "F" records and the "C" and "G"
records. I've tried the DCOUNT and COUNT functions and just keep getting
the total records from the underlying query, diplayed on each SHOPS footer.
I tried playing around with ONPAGE and ONDETAIL, but can't seem to grasp the
VB to put into it to do adding and pass that to the footer. Any ideas?
Thanks.
 
Try:
=Sum(Abs(TSC="B"))
=Sum(Abs(TSC="C"))
=Sum(Abs(TSC="F"))
=Sum(Abs(TSC="G"))
=Sum(Abs(TSC="B" OR TSC="F"))
=Sum(Abs(TSC="C" OR TSC="G"))
 
Back
Top