Ralph- Use that query as the Record Source of your form.
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: Monday, January 16, 2006 5:51 PM To: [email protected] Subject: Re: [ms_access] Querying a memo field 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 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/
