paramter query

J

JRS

I would like a query where I am prompted (thinking parameter query) for a
name such as sally. the names however in the database are merged from many
systems and there are data integrity issues......so there might be:

sally smith
smith, sally
sally marie smith
sally king
king, sally


I would like to return all names that have sally or whatever name I am
prompted for return all of those records. is there a clause I use to make
that happen? when I looked in help it seemed it had to begin with the letter
and that would give me all S. thanks
 
F

fredg

I would like a query where I am prompted (thinking parameter query) for a
name such as sally. the names however in the database are merged from many
systems and there are data integrity issues......so there might be:

sally smith
smith, sally
sally marie smith
sally king
king, sally

I would like to return all names that have sally or whatever name I am
prompted for return all of those records. is there a clause I use to make
that happen? when I looked in help it seemed it had to begin with the letter
and that would give me all S. thanks
Click to expand...

As criteria on that field, write:

To return Sally anywhere in the field....
Like "*" & [Enter the name] & "*"

To return Sally at the beginning only of the field....
Like [Enter the name] & "*"

To return Sally at the end only of the field....
Like "*" & [Enter the name]
 
K

kingston via AccessMonster.com

Try this for the query criteria:

Like "*" & [Parameter] & "*"
 
Top