Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    4

    Parameter query on memo field?

    Hi everyone,



    I have a table in my database for recording incoming customer enquiries which contains a field called 'Notes'. Notes is a memo field.

    I am trying to create a query that will enable me to search for text data and return any records that contain the text I have entered, I suppose in a similar way to the 'Find/Replace' function, but bringing up a list of records rather than clicking from one to the next using 'Find next' in a form or something.

    In design view, I have added three fields from my table to the query (ID, Enquiry Date and Notes) and I have put [Enter search text] in the critiera box under Notes.

    However, when I run the query, no records are returned even when I enter the exact text on of the records contains.

    I have heard that memo fields can be problematic, so I don't know if anyone else has encountered difficulties when trying to run a query based on this type of field. Furthermore, when I change the field type to text, it works (but I like the fact that a memo query can hold more data so I would like to keep it as this format if possible).

    Any help out there?

    Thanks a lot.

  2. #2
    Join Date
    Oct 2011
    Posts
    4
    OK solved - it wasn't the field type it was my parameter

    I changed it to Like "*" & [type prompt here] & "*" and now it works.

    Thanks anyway.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Parameter Query on a calculated field
    By l3111 in forum Queries
    Replies: 5
    Last Post: 10-12-2011, 02:18 PM
  2. Union query truncating a memo field
    By jpkeller55 in forum Queries
    Replies: 7
    Last Post: 05-27-2011, 02:17 PM
  3. Query Memo Field
    By janelgirl in forum Queries
    Replies: 7
    Last Post: 04-19-2011, 09:01 AM
  4. Replies: 4
    Last Post: 07-28-2010, 10:27 AM
  5. Replies: 2
    Last Post: 07-26-2010, 11:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums