Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query to return records NOT found (Access XP)

    My clients pay me a fee once every year. I store client

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: Query to return records NOT found (Access XP)

    Hi Ian
    There was a wizard in Access 97 that found unmatched data ...
    Your solution will probably involve two key elements

    a left join
    &
    a condition where somefieldName is Null

    e.g
    SELECT distinctrow tbl_x.fieldName FROM
    tbl_x LEFT JOIN tbl_y ON
    tbl_x.fieldName = tbl_y.fieldName
    WHERE tbl_y.fieldName IS NULL;

    It is easier with teh Wizard

    Cheers
    Geof

  3. #3
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query to return records NOT found (Access XP)

    Geof

    Thanks a lot. It is easy with the wizard!!

    Ian

Posting Permissions

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