|
 |
access thread: Countif() function
Message #1 by "Charles" <cprice@w...> on Fri, 29 Mar 2002 04:23:57
|
|
Is there an access equivelant of the Excel function COUNTIF(XX,XX). If so
what is it?
Message #2 by "Charles" <cprice@w...> on Fri, 29 Mar 2002 04:24:51
|
|
Is there an Access equivalent of the Excel function COUNTIF(XX,XX). If so,
what is it?
Message #3 by ProDev <prodevmg@y...> on Fri, 29 Mar 2002 06:05:26 -0800 (PST)
|
|
--0-1472025523-1017410726=:52411
Content-Type: text/plain; charset=us-ascii
You can use the Count and the IIf statement together. This expression below counts all records that have an ID Number greater than
5:
=Count(IIf([id]>5,[id]))
Hope this helps.
Charles <cprice@w...> wrote: Is there an Access equivalent of the Excel function COUNTIF(XX,XX). If so,
what is it?
Lonnie Johnson
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV
---------------------------------
Do You Yahoo!?
Yahoo! Greetings - send greetings for Easter, Passover
|
|
|
View Cart
