Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    11

    Unanswered: Query with right-joined criteria without matching records

    --------------------------------------------------------------------------------

    I'm feeling kind of brain dead right now. I have a query where I want to retrieve all of the records from the table on the left that DOES NOT have a matching record on the right. A little more clarity. The table on the left has orders in it and the table on the right has invoice numbers. The query is part of a DCount function and if there is an order on the left that does not have an invoice number, the count is >0. I then run an Append query. If there is a matching Invoice number, no problem. I'm having brain fades on if there isn't a record in the table on the right. Drinking is next.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    where is null
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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