mixing two queries together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, This is going to sound really bad but here it does,
I have tried doing this the write way but i can't figure out so this is the
only way i could think about doing this the wrong way

Queries one returns results

a a a
a a b
a a c
a a d
a a e
b b a
b b b
b b c
b b d
b b e
and so one
query 2 returns results
a a b 1
a a e 1
b b c 2
b b d 4

Is there a way were i can take the results from the second query where a a b
and a a e match up and have it add the fouth colum to it. Im trying to
explain it the best i can im not a programmer if you have any other ?s feel
free to ask
 
So, are you saying you'd like to see the value in the fourth column of the
second table when the first three match between table1 and table2?

First, if the data you want is in table2, why do you care what's in table1?

Second, you can join two queries the same way you would join two tables ...
in a query!

Create a new query, add the two previous queries, join on the field/fields
that are supposed to match, and select the output field/fields you want to
see.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
So basically want i want is

a a a
a a b 1
a a c
a a d
a a e 1
b b a
b b b
b b c 2
b b d 4
b b e
 
Jeff thanks for responding, but i just had a brain storming session with a
coworker and we came up with want was needed it has 2 different subquerys and
its just stupid but it works
 
Back
Top