[AccessD] Union Query WHERE Bug?

I have had inconsistent results with where clauses in union queries. Now I
create individual queries with the where clauses first then include the
resulting queries in a union query. This seems to work satisfactorily
although queries based on queries can quickly bog the machine down on large
recordsets.
Jim Hale

-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com]
Sent: Monday, April 21, 2003 7:54 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Union Query WHERE Bug?


UNION ALL forces all records to the results. 
 
Susan H. 

 

Solution:
 
After I changed the query from 'UNION' to 'UNION ALL' the filter works!!!
 
I don't know if this is a quirk in my application or Access -- or maybe the
UNION ALL ensures a unique record. :-)
 
Thanks for inspiring me to continue to hunt for the answer. Sometimes I have
to sleep on a problem to get the solution.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030422/67066168/attachment-0001.html>