matching text in a memo field

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

Guest

I'm still a novice with Access, so bear with me.

I have a single table with 4 fields. Name, date, section and content.
I am trying to build a search which will take a users input (eg "members")
and hunt throught the content field for matches and display the found records.

I've tried using "members" in the criteria but I get no-records.

The content field is type "memo" .

I can't figure out how to do this in a query, so maybe I'm barking up the
wrong tree.

Any help would be appreciated.
 
This is an example of a query that will do what you seek. I am using a
parameter ([Enter the text]) to let you enter the string to be found.

SELECT *
FROM TableName
WHERE [Content] Like "*" & [Enter the text:] & "*";
 
You would probably want to set a criteria of:
Like "*members*"
Also, before you get too far, you should change your field names so they are
not reserved words. I would use:

PersonName (or FirstName & LastName fields)
TerminationDate (or whatever your date signifies)
JailSection (or whatever your section signifies)
Content

Name is a property of every Access object
Date is a function
Every report and form have Sections
 
Back
Top