Memo fields truncated in Group queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm posting this not for resolution, but to let Microsoft and anyone else know about this "feature". If you create a query that contains a memo field and set any of the Group Totals for any field other than the memo field to something other than Group By, the memo field is truncated at about 255 characters. I found the way around it by redoing my queries, but this had stumped me for several days and I could not find anything in the Knowledge Base that covered this.

I hope that someone sees this and it helps them!
 
Thank you for posting this. You saved me a considerable amount of time
I did not create the queries in the first place so I was completely i
the dark. After reading your post, I re-wrote the queries and now
can display the entire memo field on the report.

Thanks,
Mike Matta
(e-mail address removed)


-
mikema1502
 
Back
Top