Query on Memo Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I am trying to search on a memo field using "LIKE" and am gettting no
results. The field contains resumes and I need t search for specific words to
extrat what I want. Is there any trick to this?

Thanks
 
Hey,
The LIKE criteria will filter for all records beginning with the letter(s)
specified. For example:
Like "A*" (note the *)
Will return all records where the field contents begin with the Letter A.
Maybe, if you are getting no results you are missing the * ?

Hope this helps.
 
Could you post the SQL code of that query you are looking at. I'll see if I
can make any sense of it.
 
no problem at all:

SELECT Candidates.*
FROM Candidates
WHERE (((Candidates.Resume) Like "d*"));
 
Try one of the following criteria for the memo field. The first one should
work with Access .mdb files.

LIKE "*SomeWord*"
or
LIKE "%SomeWord%"

Those represent the two different wild cards of Access Jet SQL and ANSI SQL.

If you want to turn this into a parameter query, you can use criteria like

LIKE "*" & [Enter word to find] & "*"
 
John

That worked like a charm. thanks. it's apity there's nothing written
anywhere about puting the "*" at the beginning

thanks again

John Spencer said:
Try one of the following criteria for the memo field. The first one should
work with Access .mdb files.

LIKE "*SomeWord*"
or
LIKE "%SomeWord%"

Those represent the two different wild cards of Access Jet SQL and ANSI SQL.

If you want to turn this into a parameter query, you can use criteria like

LIKE "*" & [Enter word to find] & "*"

alex said:
Hi all

I am trying to search on a memo field using "LIKE" and am gettting no
results. The field contains resumes and I need t search for specific words
to
extrat what I want. Is there any trick to this?

Thanks
Click to expand...
Click to expand...
 
Search Access help for wildcard. You should see
Character: *

Usage: Matches any number of characters.

Example: It can be used as the first or last character in the character
string.



Actually, that would have been better said as

It can be used anywhere in the character string, but is most frequently used
as the first or last character in the character string.



John

That worked like a charm. thanks. it's apity there's nothing written
anywhere about puting the "*" at the beginning

thanks again

John Spencer said:
Try one of the following criteria for the memo field. The first one
should
work with Access .mdb files.

LIKE "*SomeWord*"
or
LIKE "%SomeWord%"

Those represent the two different wild cards of Access Jet SQL and ANSI
SQL.

If you want to turn this into a parameter query, you can use criteria
like

LIKE "*" & [Enter word to find] & "*"

alex said:
Hi all

I am trying to search on a memo field using "LIKE" and am gettting no
results. The field contains resumes and I need t search for specific
words
to
extrat what I want. Is there any trick to this?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top