adding specific text string to existing field value , data 1

[russanalyst]

Hi.
I believe that I have found a way to solve a problem in a much faster manner than I thought possible. But I need some coding help.

I have a table with a field called 4/2006 which contains a text string of numbers.
How can I code a query that will add '4/2006 -' to each record's 4/2006 field value?

ex. of the results I want are: '4/2006 - 111.22' or '4/2006 - 25300.75' et cetera.

 

[jrbarnett]

Run the following SQL statement:

UPDATE table
SET [4/2006]='4/2006 - ' & [4/2006]

Just change the name "table" to your table.

John

 

[russanalyst]

Thank you so much!

Russ