Hi need to create a table.

I want 5 Five Fields

Reg ID -- Auto Number.
First Name - Text
Last Name - Text
email - Text
Phone - Number


Which i have done it.

I have problem in "Reg ID" Field. I need ID to be in this format("A0001")

But i am not able to get that . Instead i am getting 1,2,3,4 to etc.

but i need the Reg ID Field to be Auto generated in Incremental order.

A0001
A0002
A0003
A0004
A0005 etc


Kindly help.

Advance in Thanks

Either use the DMax function or just forget about the A and add it in front of the auto number dynamicaly using a query.

Also what do you intend to do when you get to A9999? It is usually more work than warrent's this appoach.

JR

Can you not use a Custom Format for the ID field in the table? A-1 becomes A-10 and eventually A-10000 without loss of sortability.