Calculated Fields

Hi Sarah, Thank you for the post, in answer to your question this requires you to create a concatenated field in a query, you will need another field which will hold the prefix we will call this field [prefix] and join this field to the autonumber field, in your query design grid in a blank field enter the following: NewID:[prefix]&[OldID] where NewID: is to be the label and [OldID] your existing autonumber field name. The concatenated field will then be available as an autonumber field in a form or table for new entries. I hope that jogged your memory, best regards Pete.