ms access - Merging Queries with no common keys -

i'm kinda new access , advice on how merge 2 queries together.

the structure of queries identical.

the column headings are: test object,test case,status,tester 1,tester 2,tester 3 , defect number

ideally want keep test object, test case, status , defect number. additionally there way merge test object , test case single field?

thanks in advance.

re: "merging" queries together

a union query type of query combines 2 (sub-)queries 1 result set, e.g.,

select [test object], [test case], [status], [defect number] yourquery1 union select [test object], [test case], [status], [defect number] yourquery2 

re: combining 2 columns

you can in access query using ampersand (&) operator concatenate:

select [test object] & ", " & [test case] object_case, ...