I'm writing a query, and I get odd results. I have a table with several fields. One of these fields is empty in some of the records (about 3500 records). I'm trying to use a Select statement to get the records with the blank field.

I have tried two different methods which <should> give the same number of selected records, but they don't.

In quasi-SQL:
First Method:

Where Field=""

Second Method:

Where Field Is Null

The ="" method yeilds 24 records. The Is Null method yeilds (the correct) 79 records.

Why do these Select modifiers behave differently? Is it an Access bug/oddity?

Baffled,
-Zeke