Query criteria in a memo field

  • Thread starter Thread starter Gamefewel
  • Start date Start date
G

Gamefewel

I have a notes field that is a memo field type. I am needing to do a query
of the field and can't figure out how to do it. The field is a multivalued
field. I tried "Allows dogs in unit" and it gave me a blank query. Can
someone help me out? I would appreciate it.

Thanks
 
Gamefewel,

I'm not sure I understand your question... Do you mean you typed "Allows
dogs in unit" in the Criteria section and nothing showed? If so you could
try placing the below on the Criteria line...

Like "*Allows dogs in unit*"

OR did you mean that your Memo field gets truncated? If that's it then you
can try these suggestions...

a. Remove the DISTINCT clause from your query
b. Remove aggregates
c. Remove any formatting

If that's not it then a wee bit more information is needed.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top