By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,967 Members | 1,740 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,967 IT Pros & Developers. It's quick & easy.

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

P: 91

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?

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.

Apr 23 '12 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,031
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.
Apr 28 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.