Auto Character Assignment

  • Thread starter Thread starter NeonSky via AccessMonster.com
  • Start date Start date
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!
 
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;

--
Ruel Cespedes
Sr. Programmer Analyst
(e-mail address removed)

Message posted via AccessMonster.com
 
Back
Top