Try
http://search.microsoft.com/us/dev/default.asp as I did.
Also show here your union statement. May be I will have an idea.
>>Union can go against nothing. What if you use UNION ALL?
>>Never met this ODBC error. Try to search MSDN Library for exact phrase "Error in assignment". It returned 10 articles for me.
>
>I looked on our January MSDN disks and got no help at all. This is a real puzzle, but ever since I started working with ODBC to access I have run across this kind of stuff.