query with the group by clause

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

WhenI create a query with the group by the text value retrieved fron the
table gets truncated ? Any reasons?
 
OCASIO said:
WhenI create a query with the group by the text value retrieved fron the
table gets truncated ? Any reasons?
Click to expand...


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.
 
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.
 
Back
Top