New Field is concatenation of other Fields

[mcg2359]

How do I add a field in a table that is equal to a concatenation of two or
more other fields?

 

[Rick B]

You don't. Search the hundreds of previous posts if you want other
examples.

This is redundant. When you need that combined data in a report, query, or
form, add an unbound text box and create it on the fly.

If you were to store it, what would happen if one of the two fields changed?

Again, do a search and you should find TONS of posts on this same topic.

Hope that helps.

 

[Larry Daugherty]

Don't do it!

Just re-concatenate the other fields each time you need to display them that
way.

HTH