Auto customer IDs

[Wull]

In Access 2007 how would I have a table create customer IDs that include letters. I am aiming at having the first 2 letters of the first and surname used. For example;

John Smith joined 1st Jan, ID = josm001
Joanne Smith joined 2nd Jan, ID = josm002

 

[boblarson]

And, Joe Smalley joined 2nd Jan, ID = josm003 ??

This can get ugly real fast. I don't know that I would go there.

 

[Wull]

lol, fair comment. I was just hoping there would be an easy way of creating a unique identifier that was a little more than the 1, 2, 3... format.

 

[boblarson]

Yeah, sometimes some things that appear to be a good idea, can in the light, become worse than ever first imagined. I believe this could be one of those