I changed the '&' to '+' and I'm still not having any luck.  This is what I have now: 

new_acct = Left(acct_id,6) + Len((acct_id)-10),'0' + Right(RTrim(acct_id),4)

And the error I'm receiving...