Update Query

  • Thread starter Thread starter DW
  • Start date Start date
D

DW

I am attempting to update records in a table based on an expression created
in the "update to" row of the update query. The expression concatenates three
text strings from three different fields. When the update runs, it will only
use the first field in the expression. How do I get the destination field to
update to the entire string created by the expression?
 
I am attempting to update records in a table based on an expression created
in the "update to" row of the update query. The expression concatenates three
text strings from three different fields. When the update runs, it will only
use the first field in the expression. How do I get the destination field to
update to the entire string created by the expression?
Click to expand...

I'm sure your message is very clear to you, unfortunately it's not at
all clear to me.

Please copy and paste into a reply message the actual update query's
SQL.

Give us an example of the values in each of the fields you wish to
concatenate, and the field's datatypes.
Give us an example of the final result you want in the field.
 
Back
Top