I need to update a table named Keynotes with a field named Keys. The problem is I need to add or insert a leading zero in the each record that has the following condition - 12345.A1 - that is I need the record to read 12345.A01 because there will be records that have 12345.A10. So I need each record to have length of 9 characters. The records 12345.A1 thru 12345.A9 only have 8 characters. Also the first five numbers can be any combination and the letter will be A thur Z.
I would like the syntax to use a Query in the Design mode with the "Update to" row. However, an SQL statement will be fine. Help - I need this for tomorrow.