Thank you. This worked very well. One other question. The results display in datasheet mode. Is there some way to have the results display in the form I created? Thanks. ralph
----- Original Message ----- From: "John Viescas" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, January 16, 2006 5:23 AM Subject: RE: [ms_access] Querying a memo field > 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 > > > > > 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/
