468,550 Members | 2,373 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,550 developers. It's quick & easy.

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


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
1 5548
1,043 Expert 1GB
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.

Similar topics

1 post views Thread by Microsoft Newsserver | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.