N
NeonSky via AccessMonster.com
Good Day!
My question is simple really.
I have a linked xcel table, one of the columns in the xcel file holds numbers
1-52.
Where numbers are 1-9 on the excel file/linked table I would like access to
assign a "0" to precede the 1-9. For example, I would like 1, 2,3 to convert
to 01, 02, 03 etc....
Thoughts?
Thanks!
My question is simple really.
I have a linked xcel table, one of the columns in the xcel file holds numbers
1-52.
Where numbers are 1-9 on the excel file/linked table I would like access to
assign a "0" to precede the 1-9. For example, I would like 1, 2,3 to convert
to 01, 02, 03 etc....
Thoughts?
Thanks!