Aged Accounts Receivable 30, 60, 90 and 120 Database Design? 1

[advpay]

I am trying to set this up so that I can do aged receivables and am trying to figure out what other fields&nbsp;&nbsp;I would need...help <br><br>tblCustomer<br>CustomerID/LastName/PrincipleBal/AgencyInt/ CurrentBal<br>&nbsp;&nbsp;990291&nbsp;&nbsp;/&nbsp;&nbsp;&nbsp;RICH&nbsp;&nbsp;&nbsp;/ $845.56 / $0.00&nbsp;&nbsp;&nbsp;/&nbsp;&nbsp;$825.18 <br>tblInvoice<br>CustomerID/BillAmt/BillDate <br>&nbsp;&nbsp;990291&nbsp;&nbsp;/845.56 /10-15-99 <br><br>tblFinDetail<br>CustomerID/TypeTrans/DescTrans/DateTrans/AmtTrans<br>&nbsp;990291/&nbsp;&nbsp;&nbsp;DBJ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/10/99Bill/10/15/99 / $845.56 <br>&nbsp;990291/&nbsp;&nbsp;&nbsp;CRJ &nbsp;&nbsp;&nbsp;&nbsp;/ADJ COR&nbsp;&nbsp;/11/24/99 / $20.40<br><br>There are many other fields but these seem to be the key ones....thanks<br>

 

[Guest_imported]

Generally unless you have to have

 

[Guest_imported]

help???

 

[gol4]

Customer table<br>custid/last/first/address/phone/etc..<br>accounttable <br>acct#/custid/dateopen/currentstatus/etc..<br>billtable<br>billid/accountid/billdate/amount/etc..<br>receivedtable<br>creditid/accountid/datereceived/amount/etc...<br>remember access is a relational database<br>use a formula in a query to compute current balance don't track in a table