add a zero to the end of a 5 digit #

R

Rick Oakley

I have a field that is 5 digits (numerical) long. I need
to add a zero to the end of all the 15,000 + entries. Any
way to do this???
 
F

fredg

I have a field that is 5 digits (numerical) long. I need
to add a zero to the end of all the 15,000 + entries. Any
way to do this???
Click to expand...

In a Select query:
ZeroAdded:[FieldName]*10

To permanently change the field data:
Update TableName Set TableName.FieldName = FieldName*10;

12345 becomes 123450
 
Top