Number generation using partial date in Access...

[randomlight]

Hello everyone,

I've been looking around for the past few hours for ways to solve my particular problem, and I happened upon this site. I appreciate any help you may offer.

The organization I work for has tasked me with designing a simple database to generate and track quote, job, and purchase order numbers and their associated information. Their quote number format is as follows: 05-1122

"05" is the last two digits of the current year, "1122" is an incremental autonumber.

I can't figure out how to grab the last two digits of the current year and insert them in an autonumber field, followed by a "-", then the autonumber. I have a book in front of me, but it's rather basic. Can someone lend me a hand?

TIA

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=184

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886