Question How to make & auto reset sequenced number (1 Viewer)

[jepoysaipan]

Hi Guys,

First, I want to create a sequenced number to be placed at the end of a time stamp then after every end of the month this number will reset again to 1.

I've got the time stamp working but can't figure out how to include the sequenced number & reset it to 1 after every beginning of the month.

Thanks in advance!

Jeff

 

[pbaldy]

You can use a DMax to get the highest number for records in the current month and add 1 to it. Wrap it in an Nz function to account for the first of the month.

 

[jepoysaipan]

Hi Paul,

Thanks for the info. can you give me an exact example? sorry I'm still new in Access. Hope you don't mind.

Thanks.

Jeff

 

[pbaldy]

Give it a whirl. There's a good reference on syntax here:

http://www.mvps.org/access/general/gen0018.htm