Access Queiries

[Guest]

I am trying to creat a perameter query that allows for a non specific answer.
What this means is i want the query, when run, to ask a question that was
typed in[] but i want it to allow for an answer that is not specific or more
forgiving llike having a *in the query. so that it would allow an answer of
say concord to bring up answers like concord park, and mis spelling as well

 

[Jeff Boyce]

In your query, in the selection "cell", you can type:
Like * & [YourPrompt] & *
to find any record with what gets entered in response to the prompt anywhere
in the field.

Misspellings are a different matter! Misspelling covers a lot of
territory -- transposition of characters, phonetic vs. dictionary, ...

Unless you can tell Access how the word(s) might be misspelled, Access can't
do magic tricks.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I am trying to creat a perameter query that allows for a non specific answer.
What this means is i want the query, when run, to ask a question that was
typed in[] but i want it to allow for an answer that is not specific or more
forgiving llike having a *in the query. so that it would allow an answer of
say concord to bring up answers like concord park, and mis spelling as

well

 

[Larry Daugherty]

In the criteria line for the field in question put
Like "*" [Enter the name ] "*"

You'll be prompted. Enter any part of the name or just hit enter to
get all names returned.

HTH
--
-Larry-
--

I am trying to creat a perameter query that allows for a non specific answer.
What this means is i want the query, when run, to ask a question that was
typed in[] but i want it to allow for an answer that is not specific or more
forgiving llike having a *in the query. so that it would allow an answer of
say concord to bring up answers like concord park, and mis spelling

as well