[AccessD] UNION query bug?

Barbara Ryan BarbaraRyan at cox.net
Fri Apr 29 12:39:08 CDT 2005


I thought that a union query (Access 97) combines the results of 2 or more queries  For example:

qryC = SELECT * FROM qryA UNION SELECT * FROM qryB;

qryA contains 1 row and qryB contains 1 row.  qryC should always produce 2 rows??

qryA contains 3 fields (Purchase Order#, Cost Acct#, Amount) from tblA
qryB contains the same 3 fields (Purchase Order#, Cost Acct#, Amount) from tblB

If the data is the same in qryA and qryB, qryC contains only 1 row.

If this is not a bug, how do I force qryC to produce 2 rows?  In my situation, qryA contains information about per diem costs and qryB contains information about bonuses, mobilization/demob costs, etc.  I need to sum these costs.  This is usually not a problem since the amounts are usually different

Thanks,
Barb Ryan




More information about the AccessD mailing list