Re: Uing the In clause in a parameter query

From: MGFoster (me_at_privacy.com)
Date: 03/25/05


Date: Fri, 25 Mar 2005 21:31:45 GMT

KP wrote:
> 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!

show the whole query

-- 
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)


Relevant Pages

  • Re: Uing the In clause in a parameter query
    ... >>>I've tried it with quotation marks around each criteria within the ... >>>parentheses as well as no quotation marks. ... >>show the whole query ... >>Oakland, CA ...
    (microsoft.public.access.queries)
  • Re: Uing the In clause in a parameter query
    ... --Build the SQL clause in VBA ... --Use the VBA function InStr ... > I've tried it with quotation marks around each criteria within the ...
    (microsoft.public.access.queries)
  • 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 ... parentheses as well as no quotation marks. ...
    (microsoft.public.access.queries)