HELP: Comparing 2 Tables

Thread View: comp.databases.ms-access

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Martinus Tunggorono Fri, 07 Feb 1997 00:00

#53

Author: 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.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads