Solved: update column

[satyen]

Does anyone know I can do an update query that appends a column by prefixing what ever is in there with "EXE-" for example.

Many thanks.

[CreganTur]

In the Update To row of the query for the field you want to update put:

"EXE-" & [ColumnName]
Where ColumnName is the name of the actual field whose value you want to update.

HTH:thumb

[satyen]

Many Thanks this worked!