grouping memo field

[Guest]

I have a query with Product Code, Product Component, and Notes (Memo).
Product Code can have many components.

Everything is fine there.
Then
I'm trying to get only Product Component and Notes (Memo) group by.
But, in the Notes, which is a memo field, I'm having something similar to
chinese signs and rectangles instead of a text.

Could anybody advise how I could fix it.

Thanks

 

[John Vinson]

I have a query with Product Code, Product Component, and Notes (Memo).
Product Code can have many components.

Everything is fine there.
Then
I'm trying to get only Product Component and Notes (Memo) group by.
But, in the Notes, which is a memo field, I'm having something similar to
chinese signs and rectangles instead of a text.

Could anybody advise how I could fix it.

Thanks

Your database may be corrupt; memo fields are notorious for such.
Grouping By a memo field will not work well; it will truncate the memo
to 255 bytes for one thing. If you open the table in datasheet view
does the memo field contain the correct information? Do you have any
Formatting on the memo field?

John W. Vinson[MVP]

 

[Guest]

Thanks, John.
This problem query is based on the previous one (without grouping). As I
said everything is fine with the memo field there. In the table everything
looks Ok as well. There is no any formating for this field in this query and
any previous queries and table.

Only this final query where I'm grouping fields, including the memo field,
shows the corrupt data in the memo field.

 

[John Vinson]

Thanks, John.
This problem query is based on the previous one (without grouping). As I
said everything is fine with the memo field there. In the table everything
looks Ok as well. There is no any formating for this field in this query and
any previous queries and table.

Only this final query where I'm grouping fields, including the memo field,
shows the corrupt data in the memo field.

Try putting in a calculated field:

MemoPiece: Left([Notes], 255)

and grouping by that; use First as the aggregate function for the memo
field. Does that help? If not, please post the SQL of the query.

John W. Vinson[MVP]

 

[Guest]

Thanks everybody.
I've done it by simplifying my queries.