Producing a total from a sub-form which has categories and placing it on main form??

[rasghar12]

Hi there,

I have a sub-form called frmLegalAidLedger on a form called profile, the sub-form has a field called Category.
I have a report which separates all the categories and then gives a total, however i need something which just gives you a total for each category which is already on the sub-form.

Just some extra info: The sub-form is in a Continuous View. There a five different categories. The calculation for the total is based on 2 fields.

Can anyone help? if you need more details please ask.

Thanks in advance.