CODEWITHSUNDEEP
sqlms-accessjoinrelationship
escapingc
escapingc

Reputation: 15

Concatenated Field Join in Access

I am trying to merge three tables into a single report and unfortunately do not have a unique key. As a result, I need to concatenate 3 fields together into one unique key. However since I am using a calculated field type, Access will not let me create a relationship between the tables. Additionally when I update the tables with new data, I am losing my calculated column.

How can I create / use a unique key using concatenated strings? How do I ensure that I don't lose the calculated column when I import new data?

Upvotes: 1

Views: 1562

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123849

Rather than concatenating 3 fields together and joining on that single concatenated field you can just join on multiple fields.

Query.png

That can work for creating Relationships too:

Relationships.png

Upvotes: 1

Related Questions