query null ??

[MikeDNova]

hey, i'm trying to run a query that uses null as part of the criteria. but i can't seem to get it to work.

i've tried "sentence"=null
isnull("sentence&quot

amongst others...

if i do a query with this as the criteria...
len(sentence)>1
then i get every row I DON'T want.

any suggestions???
thanks!
mike

 

[BlackKnight]

Hi,

'Returns records that have a name field that is null.

SELECT tblCustomer.CustomerID, tblCustomer.Name
FROM tblCustomer
WHERE (((tblCustomer.Name) Is Null));

Have a good one!
BK

 

[MikeDNova]

thank man! worked like a charm!