Auto Character Assignment

[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!

 

[Ruel Cespedes via AccessMonster.com]

The problem to your idea is Zero (0) can not be infront of a number field.
You can make a Query and there you can prefix your number field with a Zero
(0).

Here's the logic:

SELECT IIF([TableName].[FieldName]<10,"0"&[TableName].[FieldName],[TableName].
[FieldName])
AS FieldName
FROM TableName;