Queries falling apart - not containing all my values

[oliviar]

Hi Guys,
I have a query that I can't seem to use a join with, because I have to link more than one value at a time.

Sheet 1 contains:
- , B, C, D, E

Sheet 2 contains
A, B, C, D, ?

And I want sheet 3 to contain:
A, B, C, D, E

B needs to be the first value matched. If B = B, and THEN C = C and THEN D = D

Sheet 1 is just a reference array, its much much shorter than sheet 2.

A is a unique key that has to be populated at many times as the values B, C and D match.

How can this be done? I am just starting to learn Access, so any tips you have would be greatly appreciated.

 

[SydneyGeek]

Try joining table1 to table2 on B, C and D (create 3 join lines).
Then add all 5 fields to the grid.

Does that do the job?

Denis

 

[oliviar]

You can join more than 1 line at a time?!

God I'm so new at this!

I'm going to try now (although I'm scared because the SAME values appear in B, C and D all the time, overlapping - which is why I thought I had to do it in the cascading first a, then b, then c, style)