Drop n Zero form the invoice Number

[jmiller79]

I get a flat file form a customer, I import the file into a MS Access table, but somehow i need to drop the first zero form the invoice number, any help would be great

THANKS

 

[MoLaker]

Is the invoice number all numeric or does it contain alpha characters as well?

Do you need to keep any leading zeros? In other words, if the invoice is 00074, do you want to change it to 74 or to 0074?

 

[jmiller79]

I need it from 000074 to 00074. The first value in the invoice will always be a number, I just need to drop the first 0 form the invoice, it will always be a zero

THANKS

 

[MoLaker]

I see your question has been answered in your double posting in thread700-1004148.