I have a list view layout (based on Assignment table) where each record has, amongst others, a Date field (displaying date fees for assignment were received), a Fees Field (displaying the amount of fees received for an assignment), a Monthly Total field (total fees received during the current month) and a Year Total field (total fees received during the current year).
Fees field is an amount field
Monthly Total field is a summary field: Total of Fees field
Year Total field is a summary field: Total of Fees field
As you will guess, this doesn’t produce the results I’m looking for. What I want to do is this:
- If fees in the first record of the current month is $20, then Monthly Total field should show $20. Then if the second record of the month has fees of $25, Monthly Total field should show $45, etc. Then, at the beginning of the following month, the last record of the current month must continue to show the total for the current month and the first record for the following month should start computing again from zero.
- I want the Year Total field to behave the same way.
Any help would be much appreciated.