Query two fields 1

[McFestoe]

I have the following in a query which works

SELECT *
FROM Table1
WHERE (Police)=[enter police];

But i want to add another field, so the query will only list sites that equal the statment, i have tried various ways of getting to work and now i am stuck.

SELECT *
FROM Table1
WHERE (Police)=[enter police]AND SigNO=not Null;

the above returns no records at all, iam trying to get sites listed that Police=area that the user types in and SigNo is not empty.

Thanks

 

[jrbarnett]

SELECT *
FROM Table1
WHERE (Police)=[enter police] AND SigNO Is Not Null;

John

 

[McFestoe]

Jrbarnett

I can never remember the difference between = and is, = is for numeric sum and is is for fields and text.

Thanks for solving the 3hours of trying in 5mins a star for your help.

 

[jrbarnett]

The difference is that = is used for testing anything except NULL, where the word "IS" is used instead.

John

 

[jimirvine]

Hi
Just to explain WHY Null is handled differently:
A Null is a lack of a value and therefore cannot be tested with 'Normal' comparison operators. a Null can NEVER equal any value (it cannot even equal another Null) : To test that create a query that you KNOW will return results, then add on a where clause of Where Null = Null. This will Always return FALSE and therefore No records will be returned.
HTH
Jim