Date

From: arranpatel (arranpatel.13lzm9_at_nospam.MSAccessForum.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 08:17:40 -0600

I have a table called Invoice

In the table there are 8 fields

Invoice Id
ID
Amount due
Monthly payments
total due
Start_Date
End_date
Current_date

What i need to do is have the total due constant at £120
then the Monthly payment at £10
and each month for the Amount due to go down by £10

In the start date i had an expression Date() but then i realised that
it is the current date and does not stay the same ( i need it to stay
the same date as when a new record is added to the date) and the End
date i had as Date() + 365, So that it would increase the start date by
1 year for an end date, but that only chnages the current date.

how do i get those dates to stay the same?
and make it so that the Amount due goes down by £10 each month?

Thanks for any help
Arran

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Relevant Pages

  • Re: Date
    ... > I have a table called Invoice ... > and each month for the Amount due to go down by £10 ... You can get a current balance ...
    (microsoft.public.access.tablesdbdesign)
  • Date
    ... I have a table called Invoice ... Monthly payments ... and each month for the Amount due to go down by £10 ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Should I make overpayments on mortgage?
    ... and recently decided to make an overpayment of about £1600. ... received a letter telling me the monthly payments will reduce from ... I may be wrong but AFAIK a repayment mortgage is geared to pay mostly ... the total amount payable over 25 years is around 3 times the mortgage ...
    (uk.finance)
  • Re: Repayment mortgages
    ... > is paid off the loan over 25 years? ... The amount by which the monthly payments reduce the ...
    (uk.finance)
  • Re: SUM on 1 uniques record from primary table
    ... in this way I see the correct amountpaid for each invoice but the Grand total in the report footer should display the total of all amountspaid for all invoices. ... now it displays only the last amount paid. ...
    (microsoft.public.access.reports)