Count with exclusion condition

[Joallyn]

Ok, I'm sure this is a no-brainer for someone (most everyone?) out there...just not for me.

I have a "Project Tracking" database. I'm trying to set up a report that will list the numbers of projects and clients responded to during a particular time frame.

All well and good. The problem is that I want to exclude a particular client ("Internal&quot from the count of clients. If I set up the query such that it shows

Field: Client
Table: tblClient_lu
Total: Count
Sort:
Show: v
Criteria: <> &quot;Internal&quot;

I get an error. If I take out the &quot;Count&quot; criterium it works fine. Is there any way around this?

Help is--as always--much appreciated...

J

 

[fredk]

Use the first query just as you have it (you are using it to exclude &quot;internal&quot; Then create a second query based off the first query and use the count.

Hope that helps.

Fred

 

[Joallyn]

Perfect. Thanks!

 

[fredk]

Glad to help.

Fred