Re: Uing the In clause in a parameter query
From: MGFoster (me_at_privacy.com)
Date: 03/25/05
- Next message: MGFoster: "Re: Max of the Max"
- Previous message: MGFoster: "Re: Find duplicates between different fields"
- In reply to: KP: "Uing the In clause in a parameter query"
- Next in thread: KP: "Re: Uing the In clause in a parameter query"
- Reply: KP: "Re: Uing the In clause in a parameter query"
- Messages sorted by: [ date ] [ thread ]
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)
- Next message: MGFoster: "Re: Max of the Max"
- Previous message: MGFoster: "Re: Find duplicates between different fields"
- In reply to: KP: "Uing the In clause in a parameter query"
- Next in thread: KP: "Re: Uing the In clause in a parameter query"
- Reply: KP: "Re: Uing the In clause in a parameter query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|