MS Access Query - Using Nulls

Hi Experts,

When I use this:

WHERE (((USER_dbo_ams_contact.orgName) Is Not Null) AND ((USER_dbo_ams_contact.firstName) Is Not Null) AND ((USER_dbo_ams_contact.lastName) Is Not Null));

Select all Open in new window

I get way less than what I should have.

When I do this:

WHERE (((USER_dbo_ams_contact.orgName) Is Null) AND ((USER_dbo_ams_contact.firstName) Is Null) AND ((USER_dbo_ams_contact.lastName) Is Null));

Select all Open in new window

I get only 14 records

So on the first snippet (ID=8272141) I am not getting the correct number it should only be 14 less.

Please help and thanks.