Frustrating problem with notes field..

[RickDB]

I am trying to pull my information together for printing and also sending attachments. I have a field whose type is set to memo.

I have created 2 select queries, one pulls all of the information together except for the memo field, the other pulls the OrderID and the memo field. I then created a 3rd select query which merges those two back together (This is the only way I have been able to get this to work in the past).

Now, whenever I run the query, the notes field is trashed... All that is displayed is a few strange Chinese characters and that's it.

Someone please help with this, as it is a very big problem. Thanks!

 

[RuralGuy]

Maybe something in this link will shed some light. Truncation of Memo fields

 

[jeremypaule]

yeah read that. it basically says your memo field can only be 511 characters.