How to show and count empty cells for a field / table?

[sg2808]

Hi,

1.
I want to show all the records where a specific data is not populated. Currently in the database, for a specific field some cells are empty.

I am wondering, how to build the query which will show the records where the cells are empty for a specific field?

2.
Also, say, [TableA] is linked to [TableB] via junction table[JtableAB]. How do I show which records in [Table] A are not linked with [TableB]

3. How do I count the no of cells which are blank for a field?

4. How do I calculate the no of cells which are blank in a table?

Please advise.

Thanks,

[Luuk]

ah, homework ;)

1. SELECT count(*) FROM <table> WHERE <field> IS NULL;
2. sorry, i've never use 'junction'
3. see answer on question 1.
4. sorry i've only needed to know that for 1 column (see anwer to 1) , and never for a complete table.