|
 |
access thread: Keyword search in a query
Message #1 by jkeeler@g... on Wed, 18 Jul 2001 20:08:52
|
|
Maybe someone has already answered this question before but my time is
short so hopefully I can get an answer quickly.
I am wanting to use a query to create a report however the query is based
on a keyword search of a particular field in a table.
However everytime i set up the query to run and set the criteria of the
query to use a keyword to search for the data in that field and I pick a
word that I know for a fact is in that tables field all i get back is a
blank query. What am I doing wrong How do i get a query to search for a
word or phrase in a particular field in a table to print a report so that
for example:
say i have several customers who make comments about my company or one of
my competitors and this information is captured in the database what I am
trying to do is search the customers comments and based on a Keyword such
as "doing a good Job" or other words specific keywords.
from this keyword my query will bring back who said the comment about who
it was about and when it was etc.
I just am having trouble having a query do a keyword search!!
any ideas?
Message #2 by "John Ruff" <papparuff@c...> on Wed, 18 Jul 2001 12:26:46 -0700
|
|
Use the syntax Like "*doing a good job*"
The "*" before and after "doing a good job" will find any record that has
the" doing a good job" in the field.
John Ruff - The Eternal Optimist :)
-----Original Message-----
From: jkeeler@g... [mailto:jkeeler@g...]
Sent: Wednesday, July 18, 2001 8:09 PM
To: Access
Subject: [access] Keyword search in a query
Maybe someone has already answered this question before but my time is
short so hopefully I can get an answer quickly.
I am wanting to use a query to create a report however the query is based
on a keyword search of a particular field in a table.
However everytime i set up the query to run and set the criteria of the
query to use a keyword to search for the data in that field and I pick a
word that I know for a fact is in that tables field all i get back is a
blank query. What am I doing wrong How do i get a query to search for a
word or phrase in a particular field in a table to print a report so that
for example:
say i have several customers who make comments about my company or one of
my competitors and this information is captured in the database what I am
trying to do is search the customers comments and based on a Keyword such
as "doing a good Job" or other words specific keywords.
from this keyword my query will bring back who said the comment about who
it was about and when it was etc.
I just am having trouble having a query do a keyword search!!
any ideas?
Message #3 by "Pardee, Roy E" <roy.e.pardee@l...> on Wed, 18 Jul 2001 12:37:53 -0700
|
|
See the help file for the entry "About using wildcard characters to search
for partial or matching values".
HTH,
-Roy
-----Original Message-----
From: jkeeler@g... [mailto:jkeeler@g...]
Sent: Wednesday, July 18, 2001 1:09 PM
To: Access
Subject: [access] Keyword search in a query
Maybe someone has already answered this question before but my time is
short so hopefully I can get an answer quickly.
I am wanting to use a query to create a report however the query is based
on a keyword search of a particular field in a table.
However everytime i set up the query to run and set the criteria of the
query to use a keyword to search for the data in that field and I pick a
word that I know for a fact is in that tables field all i get back is a
blank query. What am I doing wrong How do i get a query to search for a
word or phrase in a particular field in a table to print a report so that
for example:
say i have several customers who make comments about my company or one of
my competitors and this information is captured in the database what I am
trying to do is search the customers comments and based on a Keyword such
as "doing a good Job" or other words specific keywords.
from this keyword my query will bring back who said the comment about who
it was about and when it was etc.
I just am having trouble having a query do a keyword search!!
any ideas?
Message #4 by "Peter Kaufman" <kaufman@l...> on Sat, 21 Jul 2001 17:48:26 +0700
|
|
Check the help on 'like operator' - that may help.
HTH,
Peter
> -----Original Message-----
> From: jkeeler@g... [mailto:jkeeler@g...]
> Sent: Wednesday, July 18, 2001 8:09 PM
> To: Access
> Subject: [access] Keyword search in a query
>
>
> Maybe someone has already answered this question before but my time is
> short so hopefully I can get an answer quickly.
>
> I am wanting to use a query to create a report however the query is based
> on a keyword search of a particular field in a table.
>
> However everytime i set up the query to run and set the criteria of the
> query to use a keyword to search for the data in that field and I pick a
> word that I know for a fact is in that tables field all i get back is a
> blank query. What am I doing wrong How do i get a query to search for a
> word or phrase in a particular field in a table to print a report so that
> for example:
>
> say i have several customers who make comments about my company or one of
> my competitors and this information is captured in the database what I am
> trying to do is search the customers comments and based on a Keyword such
> as "doing a good Job" or other words specific keywords.
>
> from this keyword my query will bring back who said the comment about who
> it was about and when it was etc.
>
> I just am having trouble having a query do a keyword search!!
>
> any ideas?
>
>
>
|
|
|
View Cart
