Uing the In clause in a parameter query

From: KP (KP_at_discussions.microsoft.com)
Date: 03/25/05 

Date: Fri, 25 Mar 2005 11:55:05 -0800

Hello!
     I'm trying to run a parameter query and use the "In" clause (e.g., "In
(400,405,500)"). For some reason Access doesn't seem to allow this with
multiple criteria -- it does work with a single number (e.g., "In (400)").
I've tried it with quotation marks around each criteria within the
parentheses as well as no quotation marks.

All help appreciated!

Relevant Pages

  • Re: Nested parentheses
    ... If one can reasonably nest quotation marks, ... where British editors, at least, have always had the choice of ... marks for parentheses. ...
    (alt.usage.english)
  • Nested parentheses
    ... PJ> (And can we have a ruling on nested parentheses (like in my ... ACB> another, but not usually more than that. ... If one can reasonably nest quotation marks, ...
    (alt.usage.english)
  • Re: Uing the In clause in a parameter query
    ... For some reason Access doesn't seem to allow this with ... > I've tried it with quotation marks around each criteria within the ... Oakland, CA ...
    (microsoft.public.access.queries)
  • Period And Quotation M ark Placement
    ... Where is the location in word where a period before or after quotation marks ... Can that be ordered for before or after parentheses ... Thanks, Rafael ... Prev by Date: ...
    (microsoft.public.mac.office.word)
  • Re: Really basic C# and Visual Studio 2008 question
    ... The quotation marks and the parentheses. ... If I highlight each one and retype the character over it, ... disappears from the list. ...
    (microsoft.public.dotnet.languages.csharp)