HELP: Comparing 2 Tables

Article View: comp.databases.ms-access

Article #53

Back to comp.databases.ms-access Previous Next

#53

From: Martinus Tunggorono
Date: Fri, 07 Feb 1997 00:00

30 lines
1446 bytes

Hello,
I someone to help me with the problem I encounter.  Obviously, I'm still 
a novice in MS Access.  My case is I have 2 tables that I have to 
compare.  Basically, one table has more information than the other.  Let 
say both table contain:

	Table 1			Table 2
        1                     1
        2                     2
        g                     g
        r                     r
        f                     
        4             
        x

I need to extract the records in table 1 that don't match the records in 
table 2 (in this case f, 4, & x)  And I don't really know where to start.  
I'm sure this is pretty easy to do for someone who has played around with 
MS Access for a while.  Any help would be greatly appreciated.




Regards,
Martinus

__
Internet: martung@bigfoot.com
*Of all the things I've lost, I miss my mind the most.

Technical Details

Message-ID: <MPG.d65c31eb07bd488989683@nntp.ix.netcom.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1668c5,6d4850a18f9aab3f,start
X-Google-Attributes: gid1668c5,public
X-Google-Thread: ff0ac,6d4850a18f9aab3f,start
X-Google-Attributes: gidff0ac,public
From: martung@bigfoot.com (Martinus Tunggorono)
Subject: HELP: Comparing 2 Tables
Date: 1997/02/07
Message-ID: <MPG.d65c31eb07bd488989683@nntp.ix.netcom.com>
X-Deja-AN: 215232607
distribution: world
organization: The Bigfoot Society
x-netcom-date: Fri Feb 07  9:44:55 PM CST 1997
newsgroups: comp.databases.ms-access,at.fido.msaccess