>Thanks Sergey. I guess i should have known to try that, since the Help message for that error states:
>
>Unions between differing column types are not allowed when one of the columns is of Memo or General type unless UNION ALL is used.
>
>But since I was using the SAME column type, i didn't think that was the problem.

Jill,

The error message is not entirely correct. It should say something like:

Unions is not allowed when one of the columns is of Memo, General or Blob type unless UNION ALL is used.