Help needed for report

[phyllisk]

I have a report that shows commission received for certain Products such as Pensions,Investments etc.
The Products category has then a sub category. For example for Investments, the sub categories are ISA's,PEP's etc.

At the report footer I have sum calculating the total commission received, however, I would to show the total commission received per Product/Product Sub Category.

Could anyone enlighten me on the correct formula?

 

[AlexMidd]

You need to set up a report group based on the sub-category. Go to the groups button (to the right of the hammer and spanner) on the Report design toolbar. Click on the down arrow in the Field/Expression column and select the sub-category field. Then set Group Footer to 'Yes'.

You can then put your text box (eg txtCommissionSubCategory)in this footer so that it appears after each sub-category in the report. The formula would be something like =Sum([txtCommission]), where txtCommission is where the commission for each item is held. The txtCommissionSubCategory box should now display after each subcategory in the report with a total for that subcategory.
(Hope this makes sense).
Have fun! )

Alex Middleton