Combine three fields into another in table

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine three fields into another in table 0
Fill in a field based on input of data in another field 5
Two Form Fields Reference The Same Table Field 4
Combine three fields into another in table 0
Update Query 2
Combining a data from a linked table and a regular table in one fo 5
Relate words in memo/text field to another table 0
Combination of fields to create records 5

Top