Results 1 to 14 of 14
  1. #1
    Join Date
    Jul 2009
    Posts
    39

    Unanswered: is equal to 2 values only, help!

    I'm making a report and
    i have a field called "memo id" and I need to filter this field out to only report records with the both memo ids "s10" and "cv10", not just records with one s10 ID or one cv10 ID but for both memo ids in the memo id field for the memo id. should be something like memo id="s10" "cv10".

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you showed neither your table layout nor your query, and did not even mention which database system you're using, so presumably you won't mind if i make stuff up
    Code:
    SELECT "memo id"
         , schnickenpflaster
         , abstlegruppen
         , complimorfle
      FROM daTable
     WHERE "memo id" IN 
           ( SELECT "memo id"
               FROM daTable
              WHERE "memo id" IN ( 's10','cv10' )
             GROUP
                 BY "memo id"
             HAVING COUNT(*) = 2 )
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2009
    Posts
    39
    Thanks smartass! but I figured it out.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by brian566 View Post
    Thanks smartass! but I figured it out.
    you're welcome, but why did you even bother posting in the first place?

    never mind replying, because i know why

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jul 2009
    Posts
    39
    {{not wise to undo edits made by mods. future reference}}
    Last edited by Teddy; 01-13-10 at 00:22.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by brian566 View Post
    YAMS YAMS YAMS YAMS YAMS YAMS YAMS YAMS YAMS YAMS YAMS YAMS YAMS YAMS YAMS
    that puerile outburst simply confirms what i suspected

    don't let the door hit you on your way out

    feel free to come back when you can behave like a grownup

    Last edited by Teddy; 01-12-10 at 18:58.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Jul 2009
    Posts
    39
    and you not standing up for yourself proves that your just a little nerdy wimp who got pick on all through high school

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by brian566 View Post
    and you not standing up for yourself proves that your just a little nerdy wimp who got pick on all through high school
    "stand up" for myself? against someone so obviously challenged as you?

    wouldn't be sporting, young fella

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Jul 2009
    Posts
    39
    Listen Limeback, just stop, for someone your age i'm surprised that your trying to argue with someone over the net.

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by brian566 View Post
    Listen Limeback, just stop, for someone your age i'm surprised that your trying to argue with someone over the net.
    arguing? who's arguing?

    i'm sitting here laughing at you, punk

    rule #1 of holes: when you find yourself in a hole, stop digging!!

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Jul 2009
    Posts
    39
    lol some old guy just called me a punk, i know im a little rascal arent I, kids these days I tell ya....

  12. #12
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    From his profile page:

    "Friends

    brian566 has not made any friends yet"

    I wonder why not??

  13. #13
    Join Date
    Jul 2009
    Posts
    39
    {{removed}}
    Last edited by Teddy; 01-13-10 at 00:04. Reason: Seriously?

  14. #14
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Well, that was disappointing.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •