concatenation without changing field name

[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.

 

[Rick B]

Then create an Update query.

 

[Guest]

UPDATE tblYour SET tblYour.txtYourField = [txtYourField] & " Bla Bla Bla";

 

[Guest]

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

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

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.

 

[Brian Bastl]

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

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

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

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.