replace or substitute

C

Chris Sergent

You can try this:
Concatenate the values around your number. It appears
that you just want the additional zeros. If that's the
case, this may work or give you an idea:
In a query, type:
MyNewFieldName: "0000000" & [MyFieldName] & "0000"
 
Top