generating desired member id

Question

hi guys,

i am using ms access 2003 database

and i want to generate different employee id's 


like for manager starts from mm0001

and increasing automatically by one


and for consultant starts from mc00001

and increasing by one automatically on registration of new consultant


plz help me how to do this