Click here to Skip to main content
15,897,704 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a field in MS-Access table that I want to increase this field value in a every month.

how could increase this field value?
Posted
Comments
Amir Mahfoozi 24-Dec-11 2:15am    
Please explain more.
ckulasekaran 24-Dec-11 3:10am    
In the specific field assign 0 value and every 1st of the month it may increase +1. (e.g) In jan month it contain 1 and feb month to increase 1+1 = 2.

1 solution

You can have another approach :
Save a specific date in a field and then compute the month difference between that saved date and another date(which may be now or another time).
By this way you need not to increase those fields every month and also unpredicted happenings do not corrupt your computation plans.
So after saving your reference date use DateDiff[^] function to computed passed moths and that is the number that is you want.
Please see this page that described similar problem :
http://www.599cd.com/tips/access/dates-datediff-dateadd/?key=AllExperts[^]

Hope it helps.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900