empty selection criteria

[mohammadagul]

ok ...
what i want is that my query should show me records which does nothave value.

forexample
field1 field2 field3
1 1
2 2 2

i want query to show me the first record in which field2 is empty. i used the following criteria

=""

in field2

but it does not work

 

[Jon K]

Put Is Null in the criteria.
.