<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=515213923-21042003><FONT face=Arial color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=515213923-21042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=515213923-21042003><FONT face=Arial color=#0000ff size=2>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?" </FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=515213923-21042003><FONT face=Arial color=#0000ff size=2>She
left me about a month later, but that's another story :-)</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV><!-- Converted from text/plain format -->
<P><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Myke
Myers<BR><B>Sent:</B> April 21, 2003 7:04 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Union Query WHERE
Bug?<BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=145002022-21042003><FONT face=Arial color=#0000ff
size=2>Solution:</FONT></SPAN></DIV>
<DIV><SPAN class=145002022-21042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145002022-21042003><FONT face=Arial color=#0000ff
size=2>After I changed the query from 'UNION' to 'UNION ALL' the filter
works!!!</FONT></SPAN></DIV>
<DIV><SPAN class=145002022-21042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145002022-21042003><FONT face=Arial color=#0000ff size=2>I
don't know if this is a quirk in my application or Access -- or maybe the
UNION ALL ensures a unique record. :-)</FONT></SPAN></DIV>
<DIV><SPAN class=145002022-21042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145002022-21042003><FONT face=Arial color=#0000ff
size=2>Thanks for inspiring me to continue to hunt for the answer. Sometimes I
have to sleep on a problem to get the solution.</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>