Queries falling apart - not containing all my values

oliviar

Board Regular
Joined
Sep 12, 2010
Messages
184
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. :confused:

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.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top