Hi I have an access database I am trying to build but am running into issues. I want to have the following tables:
Bank Accounts - List of all my bank accounts
Spending - Table that holds monthly spending. The spending will be on credit card or may come from the bank account
Inflow - Table that records monthly income
Payments - Table that records payments to credit cards and which bank the amount came from
I then want to have a query that shows the balances in the various accounts. For example i want to link the Bank Spending, Inflow and Payments which should show me the balance in the account. However when I try and do this the records from the tables go into columns instead of a seperate row for each record.
Hope this makes sense.
Thanks,
Matt