Combine Two Tables with unique info in one field I'm Lost 1

[stevedemo]

I have been trying to figure this one out for a few days and it has me completely stumped. I have tried joining the tables but I only end up with on large table. I have tried dlookup and it didn't seem to do a thing.

I only want items in the New Query from table1 where Field 2 is not in Field 2 in the second table

I have made a visual example located here:

http://www.wopto.com/help.htm

This should help explain what I am trying to do.

Thanks !!!



All I want is the chance to prove money won't make me happy.

 

[willybgw]

Use the unmatched query wizard.

 

[stevedemo]

So easy but yet so elusive.

Thanks a BILLION !!!


All I want is the chance to prove money won't make me happy.