concatenation without changing field name

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

Guest

I want to use an expression in an update query to add text to the already
existing text in a field, but I do not want to change the field name or
create a new field to accomplish this.
 
Please make this part easier for me to understand: UPDATE tblYour SET
tblYour.txtYourField

Jerry Whittle said:
UPDATE tblYour SET tblYour.txtYourField = [txtYourField] & " Bla Bla Bla";
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


George Walters said:
I want to use an expression in an update query to add text to the already
existing text in a field, but I do not want to change the field name or
create a new field to accomplish this.
Click to expand...
Click to expand...
 
George,

What Jerry offered is the SQL view of an Update query using generic table
and field names, since you didn't provide any specifics in your post.

To better understand:
Create a new query in design view. Add the table which contains the field
you want to update. From the menu bar, change the type of query to an Update
query. Select the name of the field you'd like to update. On the 'Update To'
line, type the name of the field being updated. Then go back up to the menu
bar and change the view from 'Design View' to 'SQL View'.

HTH,
Brian



George Walters said:
Please make this part easier for me to understand: UPDATE tblYour SET
tblYour.txtYourField

Jerry Whittle said:
UPDATE tblYour SET tblYour.txtYourField = [txtYourField] & " Bla Bla Bla";
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


George Walters said:
I want to use an expression in an update query to add text to the already
existing text in a field, but I do not want to change the field name or
create a new field to accomplish this.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top