Easy Update Question

[cstuckey]

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?

 

[Jaymus]

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