Do you've records with Null values in some of there fields?

>Hi All,
>
>there is shown below different SQL syntax the True one is first.:)
>the other ones when i put additional items such as comboboxes,textboxes and without any selected items from its the Syntax getting different reccounts ...the details is like under .
>What is the problem , which is wrong and what is your recommends... TIA
>
< snip >