Concatenate data from three fields to one in a table 1

[BubbaJean]

I'm using Access 2000, and I need to combine information from four fields in a table to a new field within the same table.
field1=ALUMINUM
field2=SM
field3=25V
field4=20%

newfield=ALUMINUM\SM\25V\20%
the reason i need it in the same table is my table is connected to another software application.

Hope someone can help
Thanks in advance..

 

[lespaul]

So you'll need to add your new field to the table then run an update SQL:

UPDATE tblName SET NewField = field1 + "\" + field2 + "\" + field3 + "\" + field4

(it may be '&' instead of '+', sorry I can't keep them straight!)

(Personally I would backup the database and test anything before doing it on the live data!)

HTH

leslie

 

[BubbaJean]

Thx, I'll give it a go.