my mind is just blank.. somebody help me..

[gdanalakshmi]

I have one query(qry1) that has 4 fields in its output

DeskNo ProcessID FullName ProcessText

I have another query (qry2) that has same 4 fields as above.


The DeskNo can be same also in both of the query output.

I dont know how to merge the 2 query outputs.


What query should I write to have all the records of qry1 and all the records of qry2?

 

[llkhoutx]

Build a union query in the query SQL view:

Select * from table1
Union
Select * from table2

This will tgive you a,l the records of the two tables. Using "Select *" here because the field names are the same.