增量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屋！