Copy Records

[Guest]

Records in my table are as follow ;

Acct No
---------
00100-25-1234
00104-27-1234

Question

I want to add new field in my table and to copy first 5 digit (eg 00100)
from Acct No field.

What will be the best approach.

TQ

 

[Guest]

I don't think you necessarily need to include an extra field in the table
(but would depend on the reason). Put the following into a query:

Acct: Left([Acct No],5)