[AccessD] UNION query bug?

Barbara Ryan BarbaraRyan at cox.net
Fri Apr 29 12:50:28 CDT 2005


Thanks, Susan!


----- Original Message ----- 
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Friday, April 29, 2005 1:44 PM
Subject: RE: [AccessD] UNION query bug?


> Try UNION ALL. UNION omits duplicates.
>
> Susan H.
> 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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list