Very very basic Access Question on multiple criteria in Design View

[Shales]

Hi,

Only just really started dipping my toes into Access.

I have two tables, both of which have email address in them. I need my query to do the following;

Email1
is not null
<> "N/A" (or anything like that, N/a, n/a etc)
<>"NULL"

Email2
is null

I think I need to write all the Email1 criteria's in one line but I am having no luck.

Any help would be grand.

Regards
Gavin

 

[xenou]

the Email1 criteria is written on one line with ANDs in between:
Is Not Null And <>"Null" And <>"n/a"

The Email2 criteria is written on the same line, or on a different line (the difference is on the same line makes it AND and on different line makes it OR)



String comparison is case insensitive so <>"n/a" will include N/A,n/a,N/a,n/A

 

[Shales]

Thanks very much for the syntax and thanks for the explanation.

Regards
Gavin