Rename data

[iuphim]

How can I manipulate the data within a column? I just want to rename it to something else.

Any help would be greatful.

 

[DCrake]

A bit more specific please, give examples....

 

[iuphim]

Example:

Column A

AB --> for this data field, want to rename AB to AB Revised
BC --> BC Revised

 

[DCrake]

Are we talking about renaming fields in tables?
Data in fields?

Columns tend to imply you are referring to Excel not Access. You need to be a bit more specfic to enable us to help you further.

... I have this tables called xyz and in that table is a field called abc in that field is some data which is a text type field and it contains the text QWW and I want to change it to QQW. How do I do that?.....

 

[iuphim]

Sorry I wasn't specific:

I have a table name Account and in that table is a field called Acct #, Amt, Invoice #.

For Acct # - I have text 123
For Amt - I have $12
For Invoice # - I have DS123

I want to bring Acct# (123) and Invoice #(DS) together to make a new field call Specials.

I use <Specials: (Account!Acct# & "(" & Left(Account![Invoice #],2) & ")")> and use the make a table function with fields name Specials, Amt.

I then made an append query using the new table. But when I go to make an append query, the Specials field text did not append to the table I want. Instead of 123(DS) appending to the field Specials, 123 only appends.

Is there a way to make the 123(DS) append to the table about to be appended rather than just 123?

Thanks!