Multiple Nots from a table field...

[Ecron]

hello. i saw this post http://www.access-programmers.co.uk/forums/showthread.php?t=116737
, and i was so happy because i thought it was going to be my same problem, but alas! similar, but different.

i want to know how to do a 'not' query on every value in table's field.

the query should list all of table1's field values that are NOT in table2's field values.

any help would be madly appreciated.

thanks!

 

[Ecron]

well damn.

don't you just love it when you solve your own problem after trying forever first? thanks to this post: http://www.access-programmers.co.uk/forums/showthread.php?t=116704 i was able to use their idea and come up with the solution.

SELECT * FROM table1 WHERE (table1.Field) Not In (SELECT Field FROM Table2)

yay!