Re: Queries using the <> command
From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 07/02/04
- Next message: BerHav: "RE: Help on macro !"
- Previous message: Kris L.: "Problems with Query in a Subform"
- In reply to: dallin: "Queries using the <> command"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Queries using the <> command"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Queries using the <> command"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Jul 2004 13:42:52 -0400
WHERE MyField <> "Ted" AND MyField <> "Jane"
or
WHERE MyField NOT IN ("Ted", "Jane")
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "dallin" <anonymous@discussions.microsoft.com> wrote in message news:259c701c46053$256dc740$a301280a@phx.gbl... > I've been unsuccessful on using this command for > multilple not conditions. such as <> "Ted" and > <> "Jane"? Please provide the correct syntax that allows > multiple not situations in a query. Thanks.
- Next message: BerHav: "RE: Help on macro !"
- Previous message: Kris L.: "Problems with Query in a Subform"
- In reply to: dallin: "Queries using the <> command"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Queries using the <> command"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Queries using the <> command"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
