Memo field displays as chinese character in query group by

[jeep2001]

OK wierd one here....
I have a table named comments. The comment is contained in a memo field. When I open the table and review the data it looks fine, however, if I query the comments table and group by date, the comment appears as a chinese character followed by a small square character. Anyone ever seen this one before. I changed the field to a text and it was ok...but is this a Billy Gates gotcha!

 

[dhookom]

Did you attempt to "Group By" the memo field? Or, have you tried to use "First" on the memo field?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Golom]

If you are grouping by date but not by the memo field then you must be using some aggregate function on the memo field (e.g. FIRST, LAST, MIN, MAX, etc.) Note that memo fields are not stored "in" the table. The table only contains a pointer to the memo and aggregate functions don't work on pointers ... as you have just discovered. For these same reasons you cannot JOIN or GROUP BY a memo field.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]