Auto Serial Number question

[riprod]

I am trying to assign serial numbers to a database, with one small difference. I would like to put a text suffix in the front of the number.

For example I have once field with a name (about 6 different names). When it creates the serial number I want to take the first letter from the name and put it in front of the serial number.

please help

[Chuck]

Create a second field that is a text calculation field. I'll call it User_Serial. I'm assuming that the name field is called Name and the serial number field is called Serial. The calculation would be as follows:

Left( Name, 1 ) & Serial

Chuck

[LiveOak]

I would put a text prefix in front of the number instead. -bd