Creating table for members that will update itself every month

[Automatically update records every month]

I need help to create a table or more that will automatically update itself
at the last day of every month base on the following

1. on the last day of the month (which is the start date), trigger will
count number 1 to 18 (representing 1 month to 18 months maximum) at the end
of 18 months or whatever, it will stop updating the table

2. on the start date, it will check a gross value in a field say 20,000 and
deduct 3,500 per month until the total gross of 20,000 turn to zero or until
the number 1 to 18 is turn to zero

3. or I can put a total sum to terminate the count and return the gross to
zero, that means deducting the gross amount once without continuing to count.

Please I really need assistance to create this in access 2003 database

 

[John W. Vinson]

I need help to create a table or more that will automatically update itself
at the last day of every month base on the following

1. on the last day of the month (which is the start date), trigger will
count number 1 to 18 (representing 1 month to 18 months maximum) at the end
of 18 months or whatever, it will stop updating the table

2. on the start date, it will check a gross value in a field say 20,000 and
deduct 3,500 per month until the total gross of 20,000 turn to zero or until
the number 1 to 18 is turn to zero

3. or I can put a total sum to terminate the count and return the gross to
zero, that means deducting the gross amount once without continuing to count.

Please I really need assistance to create this in access 2003 database

I'm sorry, this is making no sense.

A database doesn't "count up". It stores data. You can use Queries to select
records for a date range, but a database - by itself - doesn't start and stop
updating the table.

Do you want this update to fire every month? every second? on demand? What is
it that you're updating??? What real-life problem are you trying to solve?

John W. Vinson [MVP]

 

[Automatically update records every month]

John I am sorry to present it in a way you do not understand,

please, this is real live, I have a query “Nomal Loan Query†keeping record
of loan for friends.

from that query, I want a new query that can update another table or query
called “loanhistory†every records on demand, to check a gross value for
every record, in a field (AmountRequired) e.g 20,000 and deduct 3,500 per
month until the total gross of 20,000 turn to zero or until the number 1 to
18 (or whatever number, 18 month is maximum) is turn to zero.

On the other hand I can manually terminate the process within few months by
putting a figure to nil the outstanding a amount.

Uc