Re: Queries using the <> command

anonymous_at_discussions.microsoft.com
Date: 07/06/04 

Date: Tue, 6 Jul 2004 14:00:56 -0700

I just tried both methods, however, I still was
unsuccessful on excluding the second item. I went out in
SQL to view the code, it appears as noted below. So in
the below example it only excludes Ted not Jane? Please
provide suggestions. Thanks.

>-----Original Message-----
>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.
>
>
>.
>

Relevant Pages

  • Re: Queries using the <> command
    ... >unsuccessful on excluding the second item. ... Please open the query in SQL view and post the entire ... Come for live chats every Tuesday and Thursday ...
    (microsoft.public.access.queries)
  • Re: query prompt using SQL
    ... the commands but am unsuccessful using this in my sql query. ... You can't use a parameter with a passthrough query - the SQL server has no way ...
    (microsoft.public.access.queries)
  • Re: is the bit on or off
    ... > I have been trolling a few news groups, but so far unsuccessful. ... as I would like to use the formula in SQL (e.g. ...
    (sci.math)
  • is the bit on or off
    ... I have been trolling a few news groups, but so far unsuccessful. ... as I would like to use the formula in SQL (e.g. ...
    (sci.math)
  • Re: Update only one record
    ... numerous iterations trying to get anything to return but I was extremely ... unsuccessful. ... Access VBA but only in SQL. ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)