>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.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope