Need a String Function

[fhs]

I’ve got a six-character text field with values like: 354, 7237, 10438, some three characters long, some four characters long, and some five characters long. I need to run an update query to place sufficient “zeros” in front of each value to make it a six-character value. There are 8398 records to change! Thanks in advance.

 

[irishjoe]

I wouldn't post questions in 2 places...

 

[fhs]

I apologize for my desperation.

 

[irishjoe]

I've already answered it.
http://www.access-programmers.co.uk/forums/showthread.php?t=87623

 

[DaveJHPT]

Try updating to Format(CLng([Fieldname]), "000000")

Dave.

 

[fhs]

Dave's suggestion worked great! Let's hear it for simplicity! Thanks y'all.