I'm trying to write a query that counts the number of records in the table based on the value of specific column. I've tried using Count with the criteria set to "IIF([FieldA] = "apple",1,0) but it's not working. I don't want to just group by FIELDA because I want to explictly create a result field for categories that may not exist in the table (in which case the result is 0).
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Counting records based on field value
- Thread starter KimmieB
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question