Need to select records with empty currency field

[sync]

I've tried the following WHERE clause to return records where the 'costper' field is empty and neither return any results.

WHERE NZ([Transactions].[CostPer])=0

WHERE [Transactions].[CostPer]=0

WHERE IsNull([Transactions].[CostPer])

 

[Matt Greatorex]

Have you tried the following?

SELECT fieldname
FROM Transactions
WHERE Transactions.[CostPer] IS NULL;

 

[sync]

Thanks. I just realized that the other clauses were working. Yours is the best way to do it though.