[AccessD] Union Query WHERE Bug?

MessageUNION 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/20030421/4b5fd6aa/attachment-0001.html>