Add a leading zero to a field using an update query.
Posted on 2010-11-11
Windows XP, Access 2003, Novice user
I have a table with a field that has GL information. The GL account information can have a leading zero. So "0100" is a valid entry.
However the data was originally in Excel and Excel removed the leading zero whenever the data was exported into Excel from the IBM host system. I imported the Excel data that was provided to me into Access. I do not have access to the host system so I can't repull the data. What I currently have in the table of the database is "100".
However I need to add the leading zero back to the data in my tables. How do I do this with maybe an update query? The value I want is "0100".
The max length of the value can be 4 characters.
Thanks in advance