using ISNULL in WHERE criteria

[davyre]

Hi,
I got the SQL

SELECT TblCustOrder.PONumber, TblCustOrderUnit.OrderMethod
FROM TblCustOrder INNER JOIN TblCustOrderUnit ON TblCustOrder.CustOrderID = TblCustOrderUnit.OrderID
[highlight #FCE94F]WHERE (((TblCustOrderUnit.OrderMethod)="isnull"));[/highlight]

That does not work.
I tried this way:

SELECT TblCustOrder.PONumber, TblCustOrderUnit.OrderMethod
FROM TblCustOrder INNER JOIN TblCustOrderUnit ON TblCustOrder.CustOrderID = TblCustOrderUnit.OrderID
[highlight #8AE234]WHERE IsNull(TblCustOrderUnit.OrderMethod);[/highlight]

but when I save it, it automatically changed into the first SQL. How can I prevent that?
Or what is the correct way to do it?

 

[dhookom]

Try

SELECT TblCustOrder.PONumber, TblCustOrderUnit.OrderMethod
FROM TblCustOrder INNER JOIN TblCustOrderUnit ON TblCustOrder.CustOrderID = TblCustOrderUnit.OrderID
WHERE TblCustOrderUnit.OrderMethod is null;

Duane
Hook'D on Access
MS Access MVP