Searching a Table

[Walt]

Hi,

Can anyone tell me how I can create a form or query that will search a table
by keywords?

For example; if I wanted to retrieve data with the word access it but
someone else wanted to search on database.

Can I create a form or query that allow someone to input their keyword and
pull the info?

Thanks

 

[Golfinray]

Create a query from the table and in the query criteia that you want to
search type [enter you selection] That will give you a parameter query that
will ask the user for a keyword.

 

[Walt]

I created the query and put in [enter your selection] in the Criteria. The
parameter box pops up but when I enter a keyword it doesn't give me the data.
What am I doing wrong?

Create a query from the table and in the query criteia that you want to
search type [enter you selection] That will give you a parameter query that
will ask the user for a keyword.

Hi,

Can anyone tell me how I can create a form or query that will search a table
by keywords?

For example; if I wanted to retrieve data with the word access it but
someone else wanted to search on database.

Can I create a form or query that allow someone to input their keyword and
pull the info?

Thanks

 

[John Spencer]

If the word you are looking for could be anywhere in the field then you
need to use criteria like the following.

LIKE "*" & [Enter your selection] & "*"

If you typed Access in response to the prompt, that would return records
with Access anywhere in the field. So it would find
" the database access has "
"Accessing the database"
"Access"
etc.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I created the query and put in [enter your selection] in the Criteria. The
parameter box pops up but when I enter a keyword it doesn't give me the data.
What am I doing wrong?

Create a query from the table and in the query criteia that you want to
search type [enter you selection] That will give you a parameter query that
will ask the user for a keyword.

Hi,

Can anyone tell me how I can create a form or query that will search a table
by keywords?

For example; if I wanted to retrieve data with the word access it but
someone else wanted to search on database.

Can I create a form or query that allow someone to input their keyword and
pull the info?

Thanks

 

[John W. Vinson]

I created the query and put in [enter your selection] in the Criteria. The
parameter box pops up but when I enter a keyword it doesn't give me the data.
What am I doing wrong?

Please tell us the structure of your table and post the SQL view of the query.
We cannot tell what you are searching or how you're doing it.