Joining fields... another ? (1 Viewer)

[RIM-Pro]

I am trying to join multiple text fields and have used: =[Field-1] & " " & [Field-2] & " " & [Field-3]. Now this works, but my problem is that each of the fields that I want to join has multiple columns, and I only want to show selected columns for each one. Any ideas on how I can do that?

Thanks in advance.

 

[Pat Hartman]

It's time to re-think the table design. NO column should EVER contain multiple values. These 1-to-many relationships should be defined using separate tables. There are many rules that need to be followed when designing correct relational tables. Some of the rules can be violated for specific reasons in very limited circumstances. However, the multi-value rule should NEVER be violated under any conditions.

Go to the Microsoft support site and download the paper you will find there on table design (Q100139 - ACC Database Normalization Basics). It is a very simple description of relational table design and is a good start.