<!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.2713.1100" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=131315416-10022003><FONT face="Comic Sans MS" color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=131315416-10022003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=131315416-10022003><FONT face="Comic Sans MS" color=#0000ff
size=2>In a union query, field order is everything. The fields don't have
to have the same name, but they have to be the same datatype and in the same
order.</FONT></SPAN></DIV>
<DIV><SPAN class=131315416-10022003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=131315416-10022003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Saturday, February 08, 2003
6:46 AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B>
[AccessD] Learned Something Today<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=940353314-08022003>I learned
something today that most of you probably already know, but just in case I
thought I would pass it along - especially since it took me 2 days to figure
out what I was doing wrong.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=940353314-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=940353314-08022003>I created a Union
query using SELECT * from both tables. The Union query worked when I viewed
it, but when I tried using it to create a report & joined it to the
evaluator table, I kept getting a type mismatch in join. The main table
had the EvaluatorID as a number & the Evaluator table had EvaluatorID as
autonumber (the tables were joined by EvaluatorID). So there should not have
been any problem. All the other joins worked fine.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=940353314-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=940353314-08022003>So after
eliminating all the possible combinations and trying different tables
</SPAN></FONT><FONT face=Arial size=2><SPAN class=940353314-08022003>I
compared the 2 tables used in the Union to see if one of the fields might have
been wrong. Here is where the learning comes in! The table fields have to be
in the same Order. In one table I had EvaluatorID listed 3rd in the list &
the other it was 2nd.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=940353314-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=940353314-08022003>Another way I
found this is that I switched the order of the tables in the query, SELECT *
from table 1 UNION ALL table 2. When I did SELECT from table 2 UNION ALL table
1, I had text in the EvaluatorID field.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=940353314-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=940353314-08022003>Just thought I
would pass that along.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=940353314-08022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=940353314-08022003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>