Need a String Function

[fhs]

I’ve got a six-character length text field with values like: 354, 7237, 10438, some three-characters, some four-characters, and some five-characters. 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.

 

[MarkK]

Update to... Format([tblYourTable].[fldYourField], "000000")