Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add zero to beginning of field

Status
Not open for further replies.
Spott

Spott

Technical User
Mar 11, 2002
21
0
0
US
We're updating employee numbers from 4 digits (1234) to five digits and padding the existing numbers with a zero in front (01234) I know there's a simple way to update this, adding the zero in front through a query, but I'm stuck! Help!!
 
Sort by date Sort by votes
update myfield set myfield=format(myfield,"00000")

Mike Pastore

Hats off to (Roy) Harper
 
Upvote 0 Downvote
I think I tried it correctly and my numbers still come up 1111, 2222, 3333 instead of 01111, 02222, 03333...

[field1]=Format([field1],"00000")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
173
Andrzejek
Andrzejek
serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
303
serino
serino
RobJaxon
  • Locked
  • Question
RST .add
Replies
2
Views
64
RobJaxon
RobJaxon
JayRo71
  • Locked
  • Question
Unable to sort date field
Replies
4
Views
79
JayRo71
JayRo71
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
158
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top