Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a table of orders with various items. If [ItemID] 18 is a shirt, and [ItemID] 19 is a tie, what expression do i use to get all of those that ordered a shirt, but no tie? In other words, "18" but not "19".

    ShirtNoTie: [ItemID] ______________

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    [quote name='wsryan' post='774158' date='08-May-2009 06:22']I have a table of orders with various items. If [ItemID] 18 is a shirt, and [ItemID] 19 is a tie, what expression do i use to get all of those that ordered a shirt, but no tie? In other words, "18" but not "19".

    ShirtNoTie: [ItemID] ______________[/quote]

    You say "a table"...Do you mean two tables? I would have thought you would have an orders table, and an OrderItems table that details what items were ordered in each order?

    If that is not the case can you tell us about the structure of your table.
    Regards
    John



Posting Permissions

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