query with the group by clause

[Guest]

WhenI create a query with the group by the text value retrieved fron the
table gets truncated ? Any reasons?

 

[Marshall Barton]

WhenI create a query with the group by the text value retrieved fron the
table gets truncated ? Any reasons?

Yes. The reason is that Access does that to memo fields
used in a Group By clause. For the sake of efficiency, it
makes very little sense to group on a long, most likely
unique memo field.

You can remove the memo field from the Group By clause by
specifying the First function for the field.

 

[John Spencer (MVP)]

Guessing that the TEXT value is from a MEMO field. When Access does a Group By
query, it truncates memo fields to the first 255 characters so it can decide
what to Group By on the MEMO Field.

If you don't care which memo field you get, you can try FIRST instead of GROUP
BY on your field.