G
Guest
I copied a number field from table to a text field in another table. The
text field is a length of 7. It contains charecters that I want to front
load with zeros. For example (9 ), I want to be (0000009), a (1234 )
I want it be (0001234). Is there a way in a query to accomplish this? If
you need to write code to open the file and read all the records, identifying
the length and adding 0s, then I really need help.
text field is a length of 7. It contains charecters that I want to front
load with zeros. For example (9 ), I want to be (0000009), a (1234 )
I want it be (0001234). Is there a way in a query to accomplish this? If
you need to write code to open the file and read all the records, identifying
the length and adding 0s, then I really need help.