Question Employee number generation

[dr_thapalathy]

How can we write a query in MS Access that generates automatic employee id in the following format?

E001, E002 etc..

 

[cjard]

Why not jsut have an autonumber column storing 1, 2, 3... and when you display it, show it as "E" & Format(id, "000")