Results 1 to 8 of 8
  1. #1
    janelgirl is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    16

    Question Query Memo Field

    I have a db with 10,000+ records. In these records is a field that is a memo type, that cannot be set to another data type. I would like to query the memo field for any record that contains the words "one" or "two". However, when I add these words to the criteria rows in the query design, it does not work. I have tried the like function and using the *one* or *two*, but this also yields no results. I am sure that this is probably as obvious as can be, but I am very new to access, so I am very ignorant to the simple stuff. Is there a special way to query memo fields? Thanks!

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,549
    Show us the query that you tried.
    " it does not work." is not very helpful in pin pointing the problem or for offering advice.

  3. #3
    Rixxe is offline Blessed Bear
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Location
    London (Essex ... yep!)
    Posts
    184
    I have to say, i'm not sure there is any difference querying a memo field, apart from the fact it might be slightly difficult to select Distinct records due to its size and amount of information.

    I guess this is what you have tried but just to be sure, does this not work?

    Like "*one*"

    If not, it might be a google jobby.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,549
    Just a refinement on Rixxe's comment.
    If your looking for one or two

    use "* one *" or "* two *" You'll need the space before the search string otherwise
    you'll get none gone bone honest etc.

    The process will be long with 10000 records because every record has to be parsed for your criteria.

  5. #5
    janelgirl is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    16
    Like *one* was not working previously, as it returned less results than what I know it should have been. However, I think I MIGHT have figured this one out. I changed the "group by" to "where" and added the field back in so that I could see the results. This seems to be working, but I honestly don't know for sure without checking 10K records. Is this normally the correct way of doing this? I tried google, but that didn't really help. Sorry to be so newbie about this, and thanks for your time.

  6. #6
    janelgirl is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    16
    none, gone, and honest are fine.... There are times that it will be directly next to other text.

  7. #7
    Rixxe is offline Blessed Bear
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Location
    London (Essex ... yep!)
    Posts
    184
    Well the SQL query should be something like:

    SELECT *
    FROM TableA
    WHERE FieldA Like "*one*"

    Sorry it was hard to gauge that problem from the opening question.

    Glad you got it sorted!

  8. #8
    janelgirl is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    16
    Thanks so much!

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

Similar Threads

  1. Memo Field
    By maintt in forum Forms
    Replies: 3
    Last Post: 08-24-2010, 07:39 AM
  2. Replies: 4
    Last Post: 07-28-2010, 10:27 AM
  3. Replies: 2
    Last Post: 07-26-2010, 11:28 AM
  4. Memo field ?
    By beast_b9 in forum Access
    Replies: 2
    Last Post: 05-26-2010, 08:09 AM
  5. MEMO field
    By casporov in forum Access
    Replies: 1
    Last Post: 11-11-2006, 08:17 PM

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 - Senior Forums