Hello,
I'm new to Access, and my first 'at home' project is to create a simple database to manage my finances. I'm looking to aggregate my account balance by date, in other words, what is the total amount in my 'account' from my first entry, to each respective date. I've tried using a query that Sums [transaction amount] and Groups By [Date1], but the result is just a total of transaction for each respective date, not an aggregate total from the starting date to each date.
Would anyone know of a method of obtaining running totals by date?
Thanks!