If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ODBC linked table -- Can't group by MEMO field
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. |
#2
|
|||
|
|||
ODBC linked table -- Can't group by MEMO field
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" wrote: 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. |
#3
|
|||
|
|||
ODBC linked table -- Can't group by 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" wrote: 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" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|