countif in access?
 

Hi
ask this question in the Access usergroup :-)
You can easily do this in the query wizard choosing count as grouping
element

--
Regards
Frank Kabel
Frankfurt, Germany


Gailann wrote:
I'm trying to build a query and report in Access 2002. I need to
count records based on a criteria, similar to countif in Excel. I
don't want to use this as criteria for choosing records, however.

For example, I want to count all employees, and then tell me how many
are 100% complete with their projects.