Random Number

[MTSPEER]

Hello,



I need help Generating a Random number with alpha and numeric characters. 3 alpha and 3 numeric. Just need it to generate one number for all the records. I was thinking making it in an append query. Or if you guys can help me generate a 6 numeric number I can just update 3 of the characters with letters. thank you

[ranman256]

If you have a autonumber field, just use that with your alpha. code = "ABC" & FORMAT([autoID], "000")

[CJ_London]

have a look at this link

http://www.alvechurchdata.co.uk/hint...accrandom.html

[MTSPEER]

Hey guys thanks a lot!