Results Similar to COUNTIF

G

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?
 
T

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
 
F

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?
Click to expand...

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