Combine three fields into another in table

  • Thread starter Thread starter Ken Smith
  • Start date Start date
K

Ken Smith

Maybe the third time will be the charm. Something I am
doing (working too fast ??) is triggering the post too
soon!

Create an update query with all four fields.
In the formula for the PropertyCSZ field add this
expression:

[PropertyCity]&", "&[PropertyState]&" "&[PropertyZip]

When you run the query the formula will concatenate the
values from the other fields into a new string.

-----Original Message-----
I need to take the following fields and autopopulate
Click to expand...
another field in the same table.
 
Back
Top