Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: How do I create a query to get dates that do not match?

    I would like to run a query to see dates that do not match.

    I have a table with master dates and a table that is updated daily. Both have common field names “Wo_Del_Date”.

    I would like to run a query to see any dates that does not match.

    The wo_del_date from both tables should always be an exact match and I need to see the dates that are not.

    How can I perform this function?

    Thank you.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    ...where tbl1.[Wo_Del_Date] <> tbl2.[Wo_Del_Date]

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use the mismatch ./ missing query wizard
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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