G Guest Aug 17, 2006 #1 I have 2 tables of data and need to compare them to see which numbers are in one but not the other.
R Rick Brandt Aug 17, 2006 #2 Ian said: I have 2 tables of data and need to compare them to see which numbers are in one but not the other. Click to expand... One of the wizard choices for a new query does exaclty that. Query - New - Find Unmatched Query Wizard
Ian said: I have 2 tables of data and need to compare them to see which numbers are in one but not the other. Click to expand... One of the wizard choices for a new query does exaclty that. Query - New - Find Unmatched Query Wizard
J Jeff Boyce Aug 17, 2006 #3 Ian Click on the toolbar button that creates "new" (the drop-down part). Select "query". Use the wizard to build an "unmatched" query. -- Regards Jeff Boyce Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/
Ian Click on the toolbar button that creates "new" (the drop-down part). Select "query". Use the wizard to build an "unmatched" query. -- Regards Jeff Boyce Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/
