And what happens if you have data for Jan 2014 and data for Jan 2015? Won't those be two separate totals?
are the amount and month fields the only fields in this table? If not, how is that table set up?
And how do you want this to look on your screen?
I'm not as yet convinced that you should do this without summary fields as you can use a single summary field to show multiple monthly sub totals on the same report.
Can't you set up a relationship based on dates ? So assume your current table is called expenditure and has two fields called expenditure_date and expenditure_amount . Have a second table called total expenditure with three fields called start of month , end of month and total expenditure . The relationship could be
expenditure:: expenditure date >= total expenditure :: start of month AND
expenditure::expenditure date <= total expenditure :: end of month
Then total expenditure::total expenditure = sum(expenditure amount). Thanks kaps
Yes, that works! - Thank you, Kaps.