Too Much Data returned

[Guest]

I am somewhat new to Access so please keep things simple.

I am joining 4 different tables that each have the same key value; name.
Each table has different metrix information for the person selected. When I
look, table 1 has 3 records, table 2 has 4 records, table 3 has 5 records,
and table 4 has 6 records. When I execute the query, it joins returns 60
plus records. I understand what it is doing but not how to limit it to the
records needed only. Any ideas?

Kent

 

[Stephen Russell]

I am somewhat new to Access so please keep things simple.

I am joining 4 different tables that each have the same key value; name.
Each table has different metrix information for the person selected. When
I
look, table 1 has 3 records, table 2 has 4 records, table 3 has 5 records,
and table 4 has 6 records. When I execute the query, it joins returns 60
plus records. I understand what it is doing but not how to limit it to
the
records needed only. Any ideas?

Try a where clause to limit what you need in the supporting tables.

maybe a little schema would help.?

 

[Guest]

Not Really. I need all the data that is returned by the individual
sub-queries but when I bring it all together, it goes exponential on me.

 

[Joseph Meehan]

Not Really. I need all the data that is returned by the individual
sub-queries but when I bring it all together, it goes exponential on
me.

From what you explained, I think that is all it can do. How is it to
know what combinations you want?

 

[aaron.kempf]

you dont need a where clause.. you need a JOIN.

if queryA is returning ProductID and queryB is returning ProductID then
drag one on top of the other to make a join clause