BleepingComputer.com: Membership number field

Hi,

I am creating a database which will include 3 tables:-

A contact database
An individual members database - with membership numbers starting at MEM 00001
An corprorate members database - with membership numbers starting at ORG 00001

I only know how to do it just with numbers. Is it straightforward to create an autonumber field in this format ?

Thanks for your help.

Regards,
Julia Evans

(Moderator edit: Added Topic Description. jgw)

This post has been edited by jgweed: 02 February 2012 - 07:57 AM

I forgot to mention that I am using Access 2010 - and consider myself an "intermediate" level of Access knowledge and experience.