增量ID每月重置一次 [英] incremental ID resetting each month
问题描述
我想获得ID一个增量数字,在我的table1中简单地重置为每个
个月。谢谢,
-
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For...ccess/200808/1
i am trying to get "ID" an incremental number that simply resets to 1 each
month in my "table1" thanks,
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1
推荐答案
day()函数为您提供月中的某一天。用它来获取你的号码。
Bonnie
http: //www.dataplus-svc.com
drrajnishpatel写道:
The day() function gives you the day of the month. Use it to get your number.
Bonnie
http://www.dataplus-svc.com
drrajnishpatel wrote:
>我正在尝试得到ID一个增量数字,在我的table1中简单地重置为每个月1个月。谢谢,
>i am trying to get "ID" an incremental number that simply resets to 1 each
month in my "table1" thanks,
-
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For...ccess/200808/ 1
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1
对不起 - 使用日(现在())
bhicks11写道:
Sorry - use day(now())
bhicks11 wrote:
> day()函数为您提供月中的某一天。用它来获取你的号码。
Bonnie
http: //www.dataplus-svc.com
>>我正在尝试获取ID一个增量数字,在我的table1中简单地重置为每个月1个月。谢谢,
>>i am trying to get "ID" an incremental number that simply resets to 1 each
month in my "table1" thanks,
-
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For ... ccess / 200808/1
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1
感谢您的回复,......但我想我被误解了......
增量号码每天进入....月份从1到99,
下个月1号再次重置为1 .....谢谢
bhicks11写道:
thanks for your response,......but i think i am misunderstood....the
incremental number takes entry daily.... goes from 1 to 99 over the month and
again resets to 1 on the 1st of next month.....thanks
bhicks11 wrote:
>抱歉 - 使用day(now())
>Sorry - use day(now())
>> day()函数为您提供月中的某一天。用它来获取你的号码。
>>The day() function gives you the day of the month. Use it to get your number.
-
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe /For...ccess/200808/1
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1
这篇关于增量ID每月重置一次的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!