replicate string

[Thedon123]

what is the fucnction to copy string from one field in a table to another

 

[Tim K.]

It depends on how you want to paste the string to the target field. Do you want to copy from one field to another field in the same table or diff table? How are they related? With a unique key in both fields? One record or several records?

You can use Update query or Recordset to copy and paste string.

 

[cogent1]

You don't need a function. It can be done with an update query. Have you carefully considered the advice that Pat Hartman gave about not storing calculated values? If so, and you have determined that combining your two fields is the best scenario for you, drag the field to be updated into the grid of an update query and put the expression to combine the fields in the UPDATE TO: line.

Make sure the size of the field to be updated is adequate to contain all the characters needed.

If the target field is a primary key, the query will fail if duplicates are encountered.

 

[Thedon123]

thanks