Multiple records for one parameter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am in the Query editor window (design view) and I have on the top of the
window all the tables with all the keys selected and working. In the bottom I
have the fields with one field I wish to enter a parameter. Now I need to
enter from one to several (Work order IDs) values. If I hard code in the line
in the criteria field

IN ("WO12345","WO12346","WO12347")

this works, But if I try to make a parameter to have this entered in

IN([Enter Work Order Ids])

then enter in the work orders when prompted it doesn't work. It will accept
one work order id but not 2 or more. Why is this happening?
When prompted I have tried to enter in

"WO12345","WO12346","WO12347"
or
WO12345,WO12346,WO12347

--
MNJoe
.

Relevant Pages

  • Re: How should I generate a primary key?
    ... Obviously the designer did not get all of the business rules from the ... Should the database ... A Work Order records the transaction of a truck service at a given ... This has got nothing to do with bad design, it is about the developer trying ...
    (comp.databases)
  • Re: Can Access Do This?
    ... your initial design, the easier your life will be for years to come. ... I am trying to set a "Warranty Work Order" ... will be sent to the repair company needed. ... I would like the invoice to be ...
    (microsoft.public.access.gettingstarted)
  • Re: Would Access work?
    ... attempt to design a program with only the things that we really need. ... need to track equipment by equipment number as well as how much time is ... complex work order program is not trivial. ... for business, and be prepared to teach him your business. ...
    (microsoft.public.access.gettingstarted)
  • Setting up a short duration task between dates
    ... 5: Ship to customer ... My problem is that I have to ship on a specific date but the design and ... Then 2 hours to issue a work order. ... I have the ship date as a "Must start no later than" constraint and ...
    (microsoft.public.project2000)
  • Calculate effort for a short duration task between dates
    ... 5: Ship to customer ... My problem is that I have to ship on a specific date but the design and ... Then 2 hours to issue a work order. ... I have the ship date as a "Must start no later than" constraint and ...
    (microsoft.public.project)