G
Guest
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
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