如何增加数据库表的字段值 [英] how to increase field value of database table

问题描述

我在MS-Access表中有一个字段，希望每个月增加此字段值.

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?

推荐答案

您可以使用另一种方法:
在字段中保存一个特定的日期，然后计算该保存的日期与另一个日期(可能是现在或另一个时间)之间的月份差.
这样，您不必每月增加这些字段，而且不可预测的情况不会破坏您的计算计划.
因此，保存参考日期后，请使用 DateDiff [ http://www.599cd.com/tips/access/dates-datediff-dateadd /?key = AllExperts [ ^ ]

希望对您有所帮助.

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.

这篇关于如何增加数据库表的字段值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！