paramter query

[Guest]

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

 

[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

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]

 

[kingston via AccessMonster.com]

Try this for the query criteria:

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