add a zero to the end of a 5 digit #

[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???

 

[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???

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

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

12345 becomes 123450