I want to update Data in fields by adding a charactor to each record at the end

Ex AB6175---->AB6175A
How can this be done?

If you are just adding the same character you can use. Say the field is Part No and the table name is Inventory and we are trying to add the character A to all the Part No

Update to
[Table Name]![Field Name]&"A"

or in our example above:

[Inventory]![Part No]&"A"

That should work.

Jaymus