Update Query To Add Trailing Zero

[christy via AccessMonster.com]

I have a branchNo that is a text field. It looks like this: 21, or 61, etc.
I need the field to have a trailing zero to look like this: 210, or 610, etc.
There are about 2000 branchNo that need to be changed.

Does anyone know how to set up an Update query to add the trailing zero to my
branchNo table?

Thanks,

christy

 

[Duane Hookom]

UPDATE tblBranch
SET BranchNo = BranchNo & "0";

 

[Ken Snell [MVP]]

UPDATE Tablename
SET [branchNo] = [branchNo] & "0";

 

[christy via AccessMonster.com]

THANK YOU!!