hi everybody
if i have query 1 that contents code 1 as : a , c , e
query 2 that contents code2 : b , d , f
i want make query 3 that contets : Code 3 : a b c d e f g e
thanks
hi everybody
if i have query 1 that contents code 1 as : a , c , e
query 2 that contents code2 : b , d , f
i want make query 3 that contets : Code 3 : a b c d e f g e
thanks
into both queries add an ID field that is common (how you do that or what that ID should be depends on the specifics of your data)
code 1 as : a , c , e, X1
code2 : b , d , f, X1
then make your third query joined on the X1 field
the code is the id its unique code
If code contains the same value in both queries - then it can play the role of my X1 field and be the join field. If not, then it isn't necessary. Bottom line in order to get the fields side-by-side using 2 different record sets one must make a 3 query with a join; and in order to join there must be the same value in both. So you either use the Code value or you stuff one in artificially.