Crosstab Memo

[Guest]

I have a crosstab query with a memo field used to store comments. The
results of the memo field are odd characters rather than text. A text field
works fiine. Is there a way around this?

 

[Allen Browne]

Firstly, you cannot perform aggregate functions on the memo, so presumably
you are using something that does not aggregate, such as First. That should
work.

Typically when a Text or Memo field appears as strange characters, Access is
treating it as a binary (numeric) value instead of ASCII characters. That
can happen in a UNION query where Access is unable to determine the data
type. With memo fields, it can also represent a corruption, but normally you
would only see that in one record (a few at most).

If that's not a useful lead, post the SQL statement for your crosstab. (SQL
View, on View menu, in query design.)