[Solved] Grouping by a field and then subtotaling each group
Posted: Tue Sep 05, 2017 12:03 am
Hi all,
I'm a bit of a novice at this kind of thing, so sorry if there is a really obvious solution, but i'd appreciate any help.
I currently have a database with 4 fields (Date, Expense, Cost and Code). The 'Code' field is where I input a category for the item I'm putting into the database (e.g if I was logging a train ticket I would use the code 'TT'. I would like to create a report which groups all of the items with the same code together, then shows a subtotal at the bottom of each group (this would be the sum of all of the items in the 'Cost' field) I'd also then like a total to be displayed at the bottom of the report which would be a sum of everything in the 'Cost' field.
This is so that I could print a report of all of my expenses with different categories for each type of expense I'm claiming, so I could easily see how much I've spent in each category.
Thanks again for any help !
I'm a bit of a novice at this kind of thing, so sorry if there is a really obvious solution, but i'd appreciate any help.
I currently have a database with 4 fields (Date, Expense, Cost and Code). The 'Code' field is where I input a category for the item I'm putting into the database (e.g if I was logging a train ticket I would use the code 'TT'. I would like to create a report which groups all of the items with the same code together, then shows a subtotal at the bottom of each group (this would be the sum of all of the items in the 'Cost' field) I'd also then like a total to be displayed at the bottom of the report which would be a sum of everything in the 'Cost' field.
This is so that I could print a report of all of my expenses with different categories for each type of expense I'm claiming, so I could easily see how much I've spent in each category.
Thanks again for any help !