Re: Sum a field based on another Field
Hallo,
I have a subform with two records, Standard_fee and Session.
I have the following code on the Subform Footer : =Sum([Standard_fee]) and created a text box on the main form with the control source: =FeeDetails.Form!Total_Amount
What this does, it calculates all the standard_fee and brings the total amount on the text box on the form.
The problem I have is that, I have various Sessions i.e., 2006/07, 2007/08, 2008/09 and a student might have been studying for 2 or 3 of these sessions.
What I want the text box on the form to contain is the total fee per session per record, instead of adding all the sessions at once and giving me the total.
I might need to change my control source at the subform footer. Any ideas will be appreciated
Thanks
Hallo,
I have a subform with two records, Standard_fee and Session.
I have the following code on the Subform Footer : =Sum([Standard_fee]) and created a text box on the main form with the control source: =FeeDetails.Form!Total_Amount
What this does, it calculates all the standard_fee and brings the total amount on the text box on the form.
The problem I have is that, I have various Sessions i.e., 2006/07, 2007/08, 2008/09 and a student might have been studying for 2 or 3 of these sessions.
What I want the text box on the form to contain is the total fee per session per record, instead of adding all the sessions at once and giving me the total.
I might need to change my control source at the subform footer. Any ideas will be appreciated
Thanks