Query to Transform # of Characters in a Field

[sbf2014]

I have a table with acct numbers of various lengths, ie:

246
18
36895
352119
472

I need to run a query so that all of the acct numbers are 8 characters long with zeros as placeholders in front of the actual acct numbers, ie:

00000246
00000018
00036895
00352119
00000472

I tried using the expression NewAcctNo: 00000000+[AcctNo], but that did not fix the problem.

Any suggestions?

 

[SmallTomato]

NewAcctNo:Format([AcctNo],"000000000")

 

[sbf2014]

Amazing, thank you! Worked like a charm.