[AccessD] Count Problem

I'm confused.  The Iif returns a value conditionally but there's no
reason to use Count in an Iif if want you're looking for is either null
or [Status].  If you group on an expression like "[Status] Is Null Or
[Status] = 0", then a count on the expression would make sense.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Monday, December 08, 2008 12:09 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Count Problem

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.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com