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

  • Thread starter Thread starter JohnMontey
  • Start date Start date
J

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.
 
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.
 
If you use the Left() function in your sorting and grouping, don't forget the
"="
=Left(memofield,255)

--
Duane Hookom
Microsoft Access MVP


KARL DEWEY said:
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.


JohnMontey said:
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.
Click to expand...
Click to expand...
 
Back
Top