Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
What is the Access equivalent of Excel's COUNTIF? | Excel Discussion (Misc queries) | |||
Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions |