Unanswered: Creating totals on a form based on a sub-form?
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.
What I do in the footer of the sub foRm I put a totals field then make it hidden and in the main form I point a feild in the hidden footer field and it all done.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.