Exclude data if Termination Date populated

  • Thread starter Thread starter Charles G via AccessMonster.com
  • Start date Start date
C

Charles G via AccessMonster.com

I have a query that returns all the clients in our database. The problem is
that it counts the terminated clients as well as the current clients. We do
not want to delete the clients that are terminated, but I do not want to
count them as current clients either. In my Select Query criteria for (
[Termination Date]) what can I say to NOT count these records?

I need something like:
If populated, do not count.

-Charles-
 
You would want your query to only pull records where termination date is
null, right?

In the criteria under that field, just put...

Is null
 
I left my brain at home this morning. Thanks, I probably wouldn't have
figured that out until tomorrow.

-Chuck-
 
Back
Top