Union query is truncating fields

[mellenburg11]

I'm doing a union query on an ASP page. The returned record set for the query is truncating a field that was defined as a memo field for the two tables being read. As best as I can tell, the fields being truncated are defined the exact way in both tables, and when reading either of the tables individually, truncations doesn't occur. Has anyone else had this problem or know of a possible solution?

 

[mellenburg11]

I did a little research and found that the problem is caused by using group bys, sorts, etc... I have a where clause and an order by in the sql statement, but they are necessary.