Query to list data from one tabel that not exist in a another tabel

[arneko]

I have 2 imported Excel files imported in 2 different tabels in access.
In both tabels I have a field containing the organisation number to the firme.

I need a query that can list up info that not exist in both tabels based on the organisation number (field) that exist in both tabels

Tabel 1 contains about 2000 lines, tabel 2 only 200, but I want only those firms that not exist in table2

Tabel 1:

ID1
Company_name1
Company_orgnumber1
Data_11
Data_12

Tabel 2:

ID2
Company_name2
Company_orgnumber2
Data_21
Data_22

Please help me

 

[gemma-the-husky]

follow the query wizard for unmatched queries, or find unmatched queries

 

[arneko]

I forgot to tell you that I am using Access 2000, does this have the wizard for unmatched data