Query criteria in a memo field

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
 
G

Gina Whipp

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
 
Top