Results Similar to COUNTIF

[Gord]

So i want to run a command aganist a list of items simlar to the
COUNTIF function in Excel.

How easy is this to do?

 

[Tom van Stiphout]

On Sat, 2 Aug 2008 10:11:11 -0700 (PDT), Gord <[email protected]>
wrote:

Very easy:
select count(*)
from SomeTable
where SomeField = SomeValue

-Tom.
Microsoft Access MVP

 

[fredg]

So i want to run a command aganist a list of items simlar to the
COUNTIF function in Excel.

How easy is this to do?

=Sum(IIf([ControlName] = somecriteria,1,0))