Enter MULTIPLE Items in a Query (e.g. [Name:] ??

I've got a query set up that will return all the entries relating to a
particular Name.

The names are stored in the "Name" field.

In the Query, I simply used the [Enter First Name:] so that the user is
prompted.


Entering 1 name works great.

However, what statement do I use in the Query to allow 1 OR More to be
entered....so that it will return for one or all (basically Name1 or Name2 or
Name3.......etc)?

I've tried just entering "John" or "Mary" or "Tom" into the existing prompt,
but it doesn't seem to work.

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200601/1
.

Relevant Pages

  • Subform not consistently updating from RecordSource in Access 97
    ... The subform has a query as a recordsource that returns ... (the functions begindate() ... after the form is closed and is ignoring the query set up as the ...
    (comp.databases.ms-access)
  • Re: filter by part of name
    ... In your query set the lastName sort to ascending. ... Select the combobox in design view, ... "Russ" wrote in message ...
    (microsoft.public.access.formscoding)
  • Re: #####Using Control as a Query parameter#####
    ... > I'm have a query set up which retrieves data from a batchArchive table ... >and restores it to the 'main' Batch table. ...
    (microsoft.public.access.queries)
  • Re: Capturing the text from a Combo Box
    ... destination I need to return the distance between the two points. ... This form also includes a command button that executes a query ... that I have a query set to return the mileage value if provided the ... STRING of the selected item. ...
    (microsoft.public.access.forms)
  • Re: Update Solution. Need Help
    ... query set nor is the field in my query set. ... queries and see what happends. ... Then add the third table, as a third query; ...
    (microsoft.public.access.queries)
Loading