Add text to a price file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coverting Text File to Table 7
Add/Subtract columns from tab to tab in same file 3
update queries 4
QueryToJoineMultipleTables 2
queries to scrub for contract prices and then compare to existing 4
Checking if data exists another table and, if yes, extracting a value 0
comparing two sheet of data -- cost price increases 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top