I have a report broken into Categories. What I require is a sub-count for each category and a report total combining all the sub-totals. I'm using Access 7, and currently use "=count(*)" in the report footer, but I can't firgure out the sub-totals? Sometimes I see the formula on the actual report? Also my total for my invoice only shows the cost of the last item in the list vice a combined total for all the items?