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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

disctinct query memo field 3
how can I specify text criteria when querying a memo field 1
memo field in the select query 2
Dates in a memo field 3
Query field size quandry 2
Can I use totals on one field and still have a memo field? 4
Memo fields in a query 4
Multi-valued field query 2

Top