Sequential Numbers

Hi Jennifre
Take a look at Rick's Sequential Numbers and ISO Date Format
HTH

I made one that did a similar type of number.  did the last 2 digits of the year (22) with the Julian date (365) and sequence (000-999) for Wor Orders.  but its all in VBA.  Scott helped me with this and it works good for what I need do you wish for me to send to you send me an email will be happy to share.

This is one Richard did for me that sounds like it does EXACTALLY what you want.


Sequential Annual Coding video.

Oh wow, I forgot about this one.. you are right that's great!  You go Sandra :)

So I am still very much a beginner. I created a very basic database many years ago just to keep track of file#s. I have watched the video suggestions everyone recommended above but I don't see anything to where I can add the current month and then have it change when the month new month begins.  I don't mind adjusting the file number to a 4 digit year as suggested but I really would like to keep the 2 digit month in there and then sequentially there after, until the new year starts.  Any suggestions or another direction I can be pointed to?

If you use the month function, it will automatically change depending on the date.

Month(Date) would always be the current month, with no intervention from you.
That Sequential Annual Coding video Sandra linked should be what you are looking for. But you could use month instead of year

So Month(Date) & Year(Date) & "Hi" would on today give you a value of 112022Hi on December 1st it would automatically become 122022Hi. I don't recall what was used in the video but I assume it was DMAX. So you could do

YourFieldOrVariable=Month(Date) & Year(Date) & NZ(DMAX("FileNumber","Table",Month(DateField)=" & Month(Date) & " and Year(DateField)=" & Year(Date),0)+1