Combine Queries

[galantis]

Hi,

I have a problem to solve,

Table1:InitialMeasurement
No Quantity
1 12
2 34
3 45

Table2:FinalMeasurement
No Quantity
1 45
3 77
4 67

Table3:CombinedMeasurement
Index Initial Final
1 12 45
2 34 0
3 45 77
4 0 67

how can I join table1 and table2 to table3?

Many thanks,
Galantis

 

[MStef]

Hello galantis!
Look at "DemoCombineQryA2000.mdb"
Look at tables,
Open Form1 and click on command buton.
Look at table3.