CountIF in Access

[Pamy]

Hi
I'm wondering if Access 2k has CountIF function?
For eg, i have a form in tabular format
Year | Data
==========
Year 1 | Data
Year 2 | Data
Year 1 | Data
Can i use countif to calculate nos record for Year 1?

 

[mp9]

You can use a WHERE clause in your query instead, e.g.

SELECT Count([PutNameOfFieldToCountHere]) AS Counter
FROM PutYourTableNameHere
WHERE PutYourTableNameHere.Year='Year 1';

HTH

http://www22.brinkster.com/accessory/

 

[GHolden]

You could use DCount

ie. DCount(CountWhat,FromWhere,Condition)

See Access help for a full description.

There are two ways to write error-free programs; only the third one works.