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