Hi all…I’M Using Ms Access to develope a db…which I want to set an autonumber format like this “FAMAOR-YY-XXXXX”…The YY = Year and the xxxxx = autonumber…and the example of generate autonumber should be like this “FAMAOR0200001”…can anybody
tell me how to do this