Finding unmatched queries within 2 forms' linking column

[Stevestan]

I have 2 tables connected to each other through an "ID" column. The first table uses the ID column as the primary key so there is a value for it in every record. The second table also has an ID column, but I suspect it has records where the ID column has no value. I'd like to find out how many of the records in the 2nd table has values in the ID column. The only common link between the 2 tables is the ID column. I've tried using the unmatched query wizard, but it requires a 2nd common link between the 2 tables. Any help is appreciated!

[Oralloy]

To find the count of empty IDs, try:

SELECT COUNT(*) FROM table2 WHERE id is NULL;

And to find the count of populated IDs, try:

SELECT COUNT(*) FROM table2 WHERE id is not NULL;