Add leading zero

[Quempel]

I am looking for help on creating a query that will add a zero to an account number if it is less then 10 digits.

Any help would be much appreciated.

Thnx
Q

 

[gol4]

=iif(len(account)>10,"0" & account,account)

 

[Quempel]

O.k....I guess maybe I should explain this a bit further...

I am importing a csv file into a table. I want to make a query that will update the account # to 10 digits if it is less then 10.

 

[DotNetGnat]

something like this:

Update yourTable
SET AccountNumber = right('0000000000'+AccountNumber,10)

-DNG

 

[jebry]

Hi!

Try this:

UPDATE YourTable SET YourTable.AccountNumber = Format([YourTable.AccountNumber],"0000000000");

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[Quempel]

Thank you...That worked.

You have been very helpful.

 

[DotNetGnat]

which method worked...just for future purposes...

-DNG

 

[Quempel]

This is what I ended up using:

Right('0000000000'+[Account],10)

Thnx again

Q