Query 1

[goslincm]

I have a table that has 8 different action item fields. I want to be able to run a query that will only pull those action items with a action item due date "not null" and the action due date received field "null". So for each of my 8 action items I only want to pull those with an outstanding action item still do.

How can I do this?

 

[fneily]

Is not null
Is null

On the same criteria line if you want an AND condition.
One on the criteria line and one on the OR line if you want an OR condition.