Sorry the title is vague but I didn't know how to explain it better
I am working on a small budgeting solution based on Access for me & my family,
let's assume we have 2 accounts (one bank and one cash) & each has its own set of transactions
1) I know I could use split form with the "TOTALS" in Home -> Records to display the sum of each account however if i want to have the sum inside the table or even in a textbox it is not working
2) How can I consolidate all the accounts to find the total balance of my accounts in one place?