M mredmond Registered User. Local time Today, 02:03 Joined Oct 1, 2003 Messages 32 Mar 17, 2004 #1 If all the records in Table2 are in Table1, is there an easy way to tell WHICH records in Table1 are not in Table2?
If all the records in Table2 are in Table1, is there an easy way to tell WHICH records in Table1 are not in Table2?
jfgambit Kinetic Card Dealer Local time Today, 08:03 Joined Jul 18, 2002 Messages 798 Mar 17, 2004 #2 Use an Unmatched Query.... Select NEW from the Queries view and Select Unmatched Query...the wizard will take you through the process HTH
Use an Unmatched Query.... Select NEW from the Queries view and Select Unmatched Query...the wizard will take you through the process HTH
M mredmond Registered User. Local time Today, 02:03 Joined Oct 1, 2003 Messages 32 Mar 17, 2004 #3 Too Easy Sorry, that really makes me look dumb. Thanks for pointing that out. I should have known that.
Too Easy Sorry, that really makes me look dumb. Thanks for pointing that out. I should have known that.
jfgambit Kinetic Card Dealer Local time Today, 08:03 Joined Jul 18, 2002 Messages 798 Mar 17, 2004 #4 No...no...never think that There have been times when I can't remeber where the SAVE button is.
neileg AWF VIP Local time Today, 08:03 Joined Dec 4, 2002 Messages 5,975 Mar 18, 2004 #5 SAVE button? What's that?