ODBC linked table -- Can't group by MEMO field

[JohnMontey]

I'm using Access as a front-end for a MySQL database. I'm trying to create
grouped reports, but Access is only letting me group by Number and Date/Time
fields. I'm trying to group by a Memo field, which was originally a Text
field in MySQL. Since I can't change the data types of my linked tables, I'm
not sure what else I can do to get my grouped report. Any suggestions?

Thank you for your help.

 

[KARL DEWEY]

Memo fields have limitations but if you use the left 255 characters and then
apply your function I think it will work.

So group on Left([YourMemoField],255) and see if it works.

Same thing for sorting a memo field.

 

[Duane Hookom]

If you use the Left() function in your sorting and grouping, don't forget the
"="
=Left(memofield,255)

--
Duane Hookom
Microsoft Access MVP

Memo fields have limitations but if you use the left 255 characters and then
apply your function I think it will work.

So group on Left([YourMemoField],255) and see if it works.

Same thing for sorting a memo field.

--
Build a little, test a little.

I'm using Access as a front-end for a MySQL database. I'm trying to create
grouped reports, but Access is only letting me group by Number and Date/Time
fields. I'm trying to group by a Memo field, which was originally a Text
field in MySQL. Since I can't change the data types of my linked tables, I'm
not sure what else I can do to get my grouped report. Any suggestions?

Thank you for your help.