You are here:

Using MS Access/Counting a Blank Value in a Query

Advertisement


Question
Hello Bob,

I have a Query in Access that I want it to count only the Blank Values. The Values are in my table as a Date. I would like to count how many ones that dont have a date in the. but everything that i have tried comes up with an error or a empty cell. Please help.

Answer
Matthew,
Create a query which has one column with the following at the top.

CountOfBlanks:IIf(Isnull([Name of the field containing the blank values]),1,0)

Then make this a group by query and use the Sum on the group by row.

Bob

Further help at:
www.myaccessprogram.com  

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Bob Heifler

Expertise

ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS 
Free Microsoft Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here.

Experience

Microsoft Access programming since 1994. Support for all versions. www.myaccessprogram.com

Publications
My Microsoft Access articles are published at:DailyAccessTips.com

Education/Credentials
UCLA GRAD, Member of Association of Database Developers

Awards and Honors


Past/Present Clients
See some of my past clients here.

©2016 About.com. All rights reserved.