I had a couple of relatively simple questions this time- assuming tables can even be used to serve this purpose ><.
1. Under the table 'tblMailboxes' in the attached database, I wanted to make a field for a price that increments (preferably monthly, but daily at a smaller increment is fine too).
Some customers increment for a different value (some pay $25 monthly- some pay $15).
I was thinking that something like '(systemdate - starting date) * .15' But I don't have all of those tools available to me in a table from the looks of it.
2. I want to create a column in 'tblAccounts' that totals up all of the 'TotalDue' values from 'tblInvoices' with the same 'Account_ID'. (I want all of the values for a specific account number for an "unpaid balance" field basically).
Anyone know which direction I should head in for that?
1. Under the table 'tblMailboxes' in the attached database, I wanted to make a field for a price that increments (preferably monthly, but daily at a smaller increment is fine too).
Some customers increment for a different value (some pay $25 monthly- some pay $15).
I was thinking that something like '(systemdate - starting date) * .15' But I don't have all of those tools available to me in a table from the looks of it.
2. I want to create a column in 'tblAccounts' that totals up all of the 'TotalDue' values from 'tblInvoices' with the same 'Account_ID'. (I want all of the values for a specific account number for an "unpaid balance" field basically).
Anyone know which direction I should head in for that?
Calculations
