I do not understand you.

If you want to select all those records are in table1 but not in table2 use the query I told you. That query is a simple unmatch query.

If you want to select thosre are in both tables simply modify the where clause like WHERE ((([Table 2].hostname) = [Table 1].hostname)))


The where clause you have to use otherwise the server won't be able to narrow your selection.


To learn more about queries try to use query wizard in Access (Select queries and clik on "New").