Ralph- In SQL View, your query will look like:
SELECT MyTable.* FROM MyTable WHERE MyTable.MemoField LIKE "*" & [Enter search word:] & "*" To do this on the query grid, on the Criteria line under your memo field, enter: LIKE "*" & [Enter search word:] & "*" John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ralph Krumdieck Sent: Sunday, January 15, 2006 11:20 PM To: [email protected] Subject: [ms_access] Querying a memo field This question may not make any sense. I'm a novice at Access. I have a simple database and one of the fields in my main table is a memo field. Is it possible to write a query that would search this memo field for the word the user inputs at the prompt and returns all the records that contain that word in the memo field? ralph Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
