Working with two tables

[crackie]

Hello

I wonder how can I obtain a merged information by filtering datas from two separate tables?

The following describes my working above;

TABLE 1 - DATE, PART NAME, PART NO., QTY & COST
TABLE 2 - DATE, DO NO., PART NAME, PART NO., QTY & COST

Output = TABLE 1 data merged TABLE 2 data and information sorted as the following sequence -> DATE, DO NO., PART NAME, PART NO., QTY & COST

Thanks

 

[mpb.vu2]

Use a Union query
or, create an update query that will update data from table 1 to table 2

 

[crackie]

Use a Union query
or, create an update query that will update data from table 1 to table 2

Thanks for the feedback and guides. I'll work with the Union query and see the results at the end

Thanks