Hi all,
Im having difficulty trying to map out the ideal table composition for accounts of companies.
Basically a company usually has 4 accounts, and each account must have the following column headers:
Account 1: Manufacturing Facility in US dollars.
- date
- advances (positive amounts)
- payments (negative amounts)
- ID
- net (advances - payments)
- running outstanding balance
What I started to do was build a table with date, advance, payment and net and tried to build a query for the running outstanding balance but it caused me too much trouble. Firstly, I will enter transactions, I can have input a record with a value date in the past. I entered different variations of DSUMs field functions in my query and never got the right one. I was wondering if there would be an easier way of creating this whole database.
Any suggestions please?
Im having difficulty trying to map out the ideal table composition for accounts of companies.
Basically a company usually has 4 accounts, and each account must have the following column headers:
Account 1: Manufacturing Facility in US dollars.
- date
- advances (positive amounts)
- payments (negative amounts)
- ID
- net (advances - payments)
- running outstanding balance
What I started to do was build a table with date, advance, payment and net and tried to build a query for the running outstanding balance but it caused me too much trouble. Firstly, I will enter transactions, I can have input a record with a value date in the past. I entered different variations of DSUMs field functions in my query and never got the right one. I was wondering if there would be an easier way of creating this whole database.
Any suggestions please?