Combining several fields and storing answer in another one

[kevink]

Hello!<br>
<br>
I would like to have a field that stores the input from three other fields e.g. field1=Kevin, field2=01, field3=000 to make (new field) Kev-01-000. I can do this in a form, but can't get Access to store the answer in the table.<br>
<br>
Any ideas?<br>
<br>
Thanks,<br>
<br>
Kevin.

 

[bitbrain]

Create an update query and use the expression builder to concatenate the fields together. It will look something like this:<br>
<br>
=tab.field1 & &quot;-&quot; & tab.field2 & &quot;-&quot; & tab.field3<br>
<br>