Results 1 to 2 of 2
  1. 06-17-2014, 02:26 PM #1
    NOEL71
    NOEL71 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2014
    Posts
    9

    Unmatch Query


    Need some help in unmatch query and solution. I have build query from design view and wizard view with no problems till today. Both of the table have one ID in common their EIN/SSN. I checked both table properties and they both have data type -text and input Mask 000\-00\-0000. However when I run the query the results is different because they are still related.
    Attached Files Attached Files
    Last edited by NOEL71; 06-18-2014 at 09:34 AM.
    Reply With Quote Reply With Quote
  2. 06-18-2014, 06:55 AM #2
    JoeM
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    However when I run the query the results is different because they are still related
    I am not sure what this statement means.
    Maybe you could work us through an actual example and show us how it is not working?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Compare two tables and select records based on unmatch rules
    By rustynails in forum Queries
    Replies: 2
    Last Post: 08-10-2013, 06:06 PM
  2. Match/Unmatch Query need
    By kwooten in forum Queries
    Replies: 5
    Last Post: 11-08-2012, 01:26 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums