Formatting numbers to have a leading zero

[blacksaibot]

I have an INSERT query like so:

INSERT INTO table1 (column1, column2, column3, column4, column5)

SELECT (field1, field2, field3, field4, field1 & "" && field2)

FROM mastertable

According to the format desired by a client, column5 from table1 needs to have field1 and field2 concatenated and represented as two-digit numbers if they're a one digit (has a leading zero).


Is there a way to achieve this?

[pbaldy]

Format(Field1, "00")

[rpeare]

right("0" & field1 & field2, 2)

[rpeare]

oh if you are trying to generated a four digit text string you could do

right("0" & field1,2) & right("0" & field2, 2)

[June7]

Maybe:

Format(Field1 & field2, "00")

or

Format(Field1, "00") & Format(Field2, "00")

[rpeare]

he now has 1287340182734187230812 things to try!

[NTC]

just for the sake of completeness.... a number field type cannot have leading zeros. No way around that basic rule. So one is actually discussing a text field type......

[June7]

Also, why duplicating data?