[AccessD] Union Query WHERE Bug?

Sleep is a good thing. About two weeks ago I woke up in the middle of the
night and solved a SQL-DMO problem I had. While awake I could see the
solution, but asleep it came to me. 
 
The hardest part of this is that your lover(s) would prefer that you're
thinking about other lover(s) rather than code. My first wife once phoned me
at the office at 3:30am and I answered on the first ring and she said, "It
would be a lot easier to lose you to another woman, but a BOX? Do you know
how that makes me feel?" 
 
She left me about a month later, but that's another story :-)
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Myke Myers
Sent: April 21, 2003 7:04 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Union Query WHERE Bug?



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/e0c4316e/attachment-0001.html>