how can I specify text criteria when querying a memo field

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

When I use text in query criteria against a Memo field it is ignored. The
same criteria used against a Text field works fine. Is there a way to make
the query work for the Memo field. If not, how can I convert the Memo
field(s) using a Macro or when I import the field from Microsoft Project?
 
Hi Art,

if you want to look for a word or phrase in the memo field, put this in
the criteria on the QBE (Query-By-Example) grid under the memo fieldname:

Like "*word or phrase*"

~~~

as for converting the memo field to text -- that would be done in the
TABLE DESIGN for the field -- but text fields are limited to 255
characters, so you would need to make sure that the data you need is not
longer than that


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Back
Top