Memo Field in Query

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • blux13
    New Member
    • Apr 2007
    • 1
    #1

    Memo Field in Query

    I am having problems with a memo field in my queries. At first it was fine, but I tried to do a count on a different field in the query, and now the memo field in all my queries come up in chinese. Has anyone seen this before?
    Tags: None
    • code green
      Recognized Expert Top Contributor
      • Mar 2007
      • 1726
      #2
      Actual chinese characters or square looking zeros and the like. Pasting directly from a word doc into a memo field can cause problems

        Comment

        • MMcCarthy
          Recognized Expert MVP
          • Aug 2006
          • 14387
          #3
          Originally posted by blux13
          I am having problems with a memo field in my queries. At first it was fine, but I tried to do a count on a different field in the query, and now the memo field in all my queries come up in chinese. Has anyone seen this before?
          Basic rule is. Memo fields shouldn't be used in queries. They don't behave very well.

          Have a look at this ...

          Memo Fields in Access

            Comment

            Previous template Next
            Working...