Number to Text?!?!

[viperstingray]

Hey,

I have a small question. There is a table that I am trying to use that houses product numbers, the only problem is that those product numbers start with a '0' but the '0' got deleted because the numbers are housed in a number defined field. If I change the table properties to text, is there a way I can add a leading '0' infront of every existing product number?

Thanks,
Viperstingray

 

[Simon_MT]

Yes but I don't think its a particularly good idea.

Change the feild to test and in a update query set the field to:

"O" & [FieldName]

There are many reasons to keep the Product numbering numeric one simple involves sequencing - o1 and o10 and o100 in a text field sequence from the "left" rather than numerics which sequence from the "right".

Simon

 

[Dennisk]

use a format on the numberic field to pad out with leading zeros to obtain a fixed length field. but the data is still held internally as a number.