According to Microsofts support site (q120908)  you can include a Memo field
in a Union ALL query.  What they don't mention is if the memo field is
greater than 256 characters that the Union query will truncate the results.
Is there any way around this truncation of long Memo fields?

Thanks,
   Russell

Do a Left(Field, NumChars) On it!
Max 65535

Regards
Pieter Wijnen

Pieter,
    Thanks for your help, but this doesn't seem to work.  When I put the
Left in the union query I get an Access Violation and it kills access.  It
seems that if I use a Left value greater than 255 I get this Exception.

Thanks,
Russell