formatting ID number

[Guest]

I have a table (lots actually), and I would like to format a field "OrderID"
to equal the date and a sequence code (i.e. 090605-01). Is there a way that
I could provide a fomat such as Date()-@@ to automatically assign it to a
particular order?

 

[Arvin Meyer]

Here's an example of code that increments a number from AA001 through ZZ999.
It could be adapted to do what you want:

http://www.datastrat.com/Download/AlphaNumeric2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access