If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query criteria in a memo field
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 |
#2
|
|||
|
|||
Query criteria in a memo field
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 "Gamefewel" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|