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

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
http://mvp.support.microsoft.com/

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


"Need Access Help" <Need Access (E-Mail Removed)> wrote in
message news:3E45C06A-7477-4537-B8AB-(E-Mail Removed)...
> 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

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-
--

"Need Access Help" <Need Access (E-Mail Removed)> wrote
in message news:3E45C06A-7477-4537-B8AB-(E-Mail Removed)...
> 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