I need to restart my ID number each year. I can create a unique number sequence using the ELookup Function, but how do I get it to start over from ID06-033 to ID07-001 in January 2007?
I posted this yesterday, but I guess there was a problem with my userid or something.
TheAceMan1 posted a reply, but I did not get to read it and I can't find the post now. Here goes again:
Reference thread702-1172513
The referenced thread shows how to create a numbering system based on the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.