G Guest Mar 23, 2005 #1 How do I add a field in a table that is equal to a concatenation of two or more other fields?
R Rick B Mar 23, 2005 #2 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.
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.
L Larry Daugherty Mar 24, 2005 #3 Don't do it! Just re-concatenate the other fields each time you need to display them that way. HTH
