Re: [MS_AccessPros] Counting fields if they are null

 

Thank You John.

 

Jim Wagner

---

On Monday, February 16, 2015 7:45 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

Jim-

SELECT -Sum(IsNull([ATO to HO]))

FROM MyTable

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 16, 2015, at 3:28 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a table that have null values for several fields. I would like in a query to count how many records have null values for a specific field. The field is a date format

the name of the field is ATO to HO. Believe you me, I did not name the fields. Is there a way to do that?

 

Jim Wagner

---

__._,_.___

---

Posted by: Jim Wagner <luvmymelody@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___