: Sum a field based on another field

[dr223]

Hallo,

I have a Form built with a subform. The subform has two fields
1) Standard_fee - displays the fees paid at various sessions
2) Session - which year of study i.e., 2006/07, 2007/08, 2008/09

I want to sum the fees per record depending on the session of study. This is mainly because for example for the Session 2006/07, a student might have 3 payers (sponsors) for his fees, and in 2007/08, two payers.

The record will display all the Fee Amounts and Sessions respectively. What I want to do is to be able to find the SUM of the Fees per session and display the result. Also, be able to move from one session to another and checking the total amount of fees paid.

Any suggestions on how I can tackle that!!!

Any help will indeed be highly appreciated.

Thank you!!!

 

[MStef]

Send a short example of your mdb, (access 2000 or 2002).

 

[dr223]

Mstef

I am working with access 2003 will you be able to open it ?

Thanks

 

[MStef]

No, i can't open A2003, convert it in 2002 or 2000.