Sure. I don't see why not. Use DateSerial to put together 1/1 of the current year. Use DateDiff to determine how many days from then until now. Use Format to assemble the current date/time as you want it. Then smash em all together. :)

I'll give it a try later and let you know.

Remember, you can do it all in one statement, but it's easier if you break it down into steps.

Gotcha. Haven't quite learned about dateserial yet so that will be interesting. Formatting it should be either in the format tab or maybe an input mask with all numbers?

I'm thinking this could be an alternative to an OrderID and would probably only show on an invoice or paid orders.

Just use the Format function. If you finish this entire class and still have questions, let me know. DateSerial is a great function.

Finally had some time to really work on this. It was super easy. The only thing I had an issue with at first was formatting the time because it was displaying the AM/PM, but as soon as I put Format([Time], "hhnnss") into the control source tab, it worked flawlessly.

So now it displays as days passed since 1/1, mmddyy, hhnnss, and autonumber (293)-(090920)(093342)(1)

Awesome!