Conditional Counting?

[justplaincorey]

First time user here.

I have two tables that I want to count a certain result. One table is called "Orgs" and the other is called "Apps". There is a field in "Apps" called "Status".



I am looking to return Name and Address from "Orgs" for any Org which has a zero count in "Apps" for "Status" being "Approved".

I tried a simple SELECT from both tables but it would not allow me to use Count([Apps].[Status]) = 0 as a criteria.

Can someone point me in the right direction, please?

[ItsMe]

Can you post the entire SQL? You need to make sure your Count() function is included in the SELECT statement before you can include it in the WHERE clause.