Add text to a price file

E

edward keith

I have a price table that the first column shows the old part number and the
second column shows the new part number. I need to add the word "USE" to the
front of each record in the second column. Can you help?
Thank you,
Edward Keith
 
S

Steven M. Britton

In a query you would make the field name

New_Part: "USE - " & [secondcolumnname]

You can also you the expression builder to make this and just type what I
have then goto to tables and select the column you are interested in... this
will ensure the correct reference.

-Steve
 
Top