<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>