<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=390013721-18042003><FONT face=Arial color=#0000ff size=2>is the
number actual text or a true number?<BR>If it's a number you might
try:</FONT></SPAN></DIV>
<DIV><SPAN class=390013721-18042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=390013721-18042003>
<DIV><FONT color=#000080><FONT face=Arial><FONT size=2>SELECT *<SPAN
class=390013721-18042003> </SPAN>FROM quniCEIncompleteCredits<SPAN
class=390013721-18042003> </SPAN>WHERE RepNum=8222</FONT></FONT></FONT></DIV>
<DIV><FONT color=#000080><FONT face=Arial><FONT color=#0000ff size=2><SPAN
class=921022018-18042003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT face=Arial color=#0000ff size=2><SPAN
class=921022018-18042003><SPAN
class=390013721-18042003>Regards,</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT face=Arial color=#0000ff size=2><SPAN
class=921022018-18042003><SPAN class=390013721-18042003>Eric
S.</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT color=#000080><FONT face=Arial><FONT color=#0000ff size=2><SPAN
class=921022018-18042003></SPAN></FONT></FONT></FONT> </DIV>
<DIV></SPAN><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> vrijdag 18 april 2003 21:53 <BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Union Query WHERE
Bug?<BR><BR></FONT></DIV></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Tahoma size=2><SPAN class=921022018-18042003>Can anyone
explain why this query returns one record, as it should...</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2></FONT> </DIV>
<DIV><FONT color=#000080><FONT face=Arial><FONT size=2>SELECT
quniCEIncompleteCredits.*<BR>FROM quniCEIncompleteCredits<BR>WHERE
(((quniCEIncompleteCredits.RepNum) Like "8222"));<SPAN
class=921022018-18042003><FONT
color=#0000ff> </FONT></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT color=#000080><FONT face=Arial><FONT size=2><SPAN
class=921022018-18042003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT color=#000080><FONT face=Arial><FONT size=2><SPAN
class=921022018-18042003><FONT color=#ff0000>And this query returns no
records?.</FONT> </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial color=#000080 size=2></FONT> </DIV>
<DIV><FONT color=#000080><FONT face=Arial><FONT size=2>SELECT
quniCEIncompleteCredits.*<BR>FROM quniCEIncompleteCredits<BR>WHERE
(((quniCEIncompleteCredits.RepNum)="8222"));<SPAN
class=921022018-18042003><FONT
color=#0000ff> </FONT></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT color=#000080><FONT face=Arial><FONT size=2><SPAN
class=921022018-18042003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2></FONT> </DIV>
<DIV><SPAN class=921022018-18042003><FONT face=Arial color=#000080
size=2>Using Access 2000. 'quniCEIncompleteCredits' is a union
query.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN
class=921022018-18042003>TIA,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#000080 size=2></FONT> </DIV>
<DIV><STRONG><FONT face=Arial><FONT color=#000080><FONT
size=2>Myke</FONT></FONT></FONT></STRONG></DIV>
<DIV><STRONG><FONT face=Arial><FONT color=#000080><FONT size=2>The Better
Information Group</FONT></FONT></FONT><FONT size=2><FONT color=#000080><FONT
face=Arial></FONT></FONT></STRONG></FONT></DIV>
<DIV>
<DIV><STRONG><FONT face=Arial color=#000080
size=2></FONT></STRONG></DIV></DIV></BLOCKQUOTE></BODY></HTML>
<html>
<BR><BR>
<TABLE width=400><HR>
<P style="FONT: 9pt/11pt verdana"><a href="http://www.avast.com">avast! Antivirus</a>: Outbound message clean.
<P style="FONT: 8pt/11pt verdana">Virus Database (VPS): 17-4-2003<BR>Tested on: 18-4-2003 23:40:06<BR><FONT color=gray>avast! is copyright (c) 2000-2003 ALWIL Software.</FONT></P>
<TBODY></TBODY></TABLE>
<BR></html>