NEED HELP in Access Table

[srinayana]

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

 

[namliam]

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

 

[JANR]

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

JR

 

[wilpeter]

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.