Hi all,
Silly easy question here.

How can I go about generating a number in the format
'AAA000"
AAA001"
...
AAA999
AAB001
...
AAZ999
ABA000vance
...

I need to be able to do this in Access (yuk) and so I cant use any fancy VB functions.

Thanks in Advance