sql not returning full string from memo field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tyrone Smith - 02 Dec 2005 01:18 GMT

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?

Reply to this Message

Allen Browne - 02 Dec 2005 02:07 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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?
[quoted text clipped - 3 lines]
>
> What am i doing wrong?

Reply to this Message