Queries-Retrieving specific records

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

I created a single database with several fields. I am
attempting to create a query that will allow my users to
enter information in a parameter box and have it retreive
possible matching records (using partial information). My
users do not know how to use the "Find" command in a
table. The will be retreiving all their information via
forms and reports that I create and tie back to queries.

I can create a parameter query, however, when I enter
information, it does not retreive any records. If I leave
the parameter blank it retreives all the records. I know
this is a simple error on my part, but I am not sure how
or where to correct it.

I could be using the wrong format for this, not sure
I am using Access 2002

Thanks Linda Reedy
 
Linda said:
I created a single database with several fields. I am
attempting to create a query that will allow my users to
enter information in a parameter box and have it retreive
possible matching records (using partial information). My
users do not know how to use the "Find" command in a
table. The will be retreiving all their information via
forms and reports that I create and tie back to queries.

I can create a parameter query, however, when I enter
information, it does not retreive any records. If I leave
the parameter blank it retreives all the records. I know
this is a simple error on my part, but I am not sure how
or where to correct it.

I could be using the wrong format for this, not sure
I am using Access 2002

Thanks Linda Reedy
Click to expand...

Try this
Like "*" & [question] & "*"
 
Back
Top