That makes sense. Thank you very much.
ralph
> -----Original Message-----
> From: [email protected]
> [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas
> Sent: Monday, January 16, 2006 8:30 PM
> To: [email protected]
> Subject: RE: [ms_access] Querying a memo field
>
> 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
>
>
>
>
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/
