[AccessD] Count Problem

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon Dec 8 14:09:23 CST 2008


I am having trouble with the count function.
If I do a count of the field Status in a table for a status code of  "FL"  I get 0
If I use the following formula I get 1. Is it counting the number of nulls?
StatusCount:Iif(Count([Status]=0,Null,Count([Status]))

If so how do I get it to return a value of NULL?

Thanks.


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.




More information about the AccessD mailing list