sql not returning full string from memo field

  • Thread starter Thread starter Tyrone Smith
  • Start date Start date
T

Tyrone Smith

I have an sql statment that returns a memo field as part of the result,
proble is it isn't returning the full string in the memo field?

And yet i have other sql that does similar and it returns the entire memo
string.

What am i doing wrong?
 
If JET has to perform any aggregation on the memo field, it will truncate at
255 characters.

If you are using a Totals query, using GroupBy in the Total row performs
aggregation. Change it to First, and JET is free to return the whole field
for the first match it finds.

If it is not a Totals query, make sure the SQL Statement does not contain
DISTINCT, which also forces comparision/aggregation.
 
Back
Top