P
Pat Briggs
I imported a spreadsheet that was set-up incorrectly using the '0123456 to
keep the leading 0's in and didn't realize it. Now I have thousands of
records that need the leading 0 put back in. Is there a way to write an
update query to do them or am I stuck adding the 0 in one at a time? I tried
formating the table but it didn't change anything.
keep the leading 0's in and didn't realize it. Now I have thousands of
records that need the leading 0 put back in. Is there a way to write an
update query to do them or am I stuck adding the 0 in one at a time? I tried
formating the table but it didn't change anything.