S ssworthi Registered User. Local time Today, 15:15 Joined Jun 9, 2010 Messages 97 Jun 16, 2011 #1 I have two tables; table one has all the values, table two has values I want to exclude. Would I create a query excluding by using "not like " and then do another to get the values that I want? Just not sure how to do this. Thanks so much!
I have two tables; table one has all the values, table two has values I want to exclude. Would I create a query excluding by using "not like " and then do another to get the values that I want? Just not sure how to do this. Thanks so much!
A Anchoress Registered User. Local time Today, 15:15 Joined May 29, 2007 Messages 71 Jun 16, 2011 #2 The sticky thread at the top of the Queries forum tells you how to do exactly that.
S ssworthi Registered User. Local time Today, 15:15 Joined Jun 9, 2010 Messages 97 Jun 16, 2011 #3 Thank you, thank you! Worked perfect!