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-
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total count of multiple fields?... Is that possible? 11
Count of Groups 5
Adding data in a 2nd query 5
Query Parameters 1
Today's Date in Update Query 10
Cross tab query 5
query drops records 2
Query for two fields in one record that do not match 3

Back
Top