HOW DO I USE COUNTIF FUNCTION ACCESS 2007 ?

  • Thread starter Thread starter Udaya
  • Start date Start date
You don't. COUNTIF is an Excel function. Access is not Excel.

In Access, you would need to construct a query which returns the records
meeting your desired criteria, and apply the COUNT function to a field in
the SELECT list.

n.b. posting in all capitals is considered to be SHOUTING and therefore
impolite.
 
SELECT Count(IIF(SomeField='something',1,Null)) as CountSomething
FROM YourTable

OR Use the DCount function
DCount("*","YourTable","SomeField = 'Something'")

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Just a big Thank You! Anything can be done if you want it bad enough. I get tired of the "Access" can't do it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF 1
formula similar to "countifs" function in excel 2007 2
VBA Countif across sheets? 5
Countif and Right functions 8
Excel Copy COUNTIF while retaining reference 7
Excel Use COUNTIF across a range of cells with formulas 0
what is the function to countif in MS Access? 1
IF function in Query 2

Back
Top