Problems with returning blank fields for certain records query

[rebfein]

Hi there,



I'm having a problem creating a query for a particular set of records with blank fields. Please let me know where I'm going wrong (and keep in mind that I don't know SQL).

Situation:
I need to create a list of a certain set of parts (about 8 sub-categories out of 40) that return a blank field for the manufacturer name. The table itself totals over 11 thousand records. I'm estimating that the records without a name in the manufacturer field totals ~ 800. Here's a picture of the query design:


1. I selected Create>Queries>Query Design, and added the table name.
2. From there I selected three fields I wanted for the query; our PN, the MFG Part and the manufacturer name (MFG)
3. In the KGS PN column, criteria, I added a statement to look for part numbers that begin with the following letters; CC, CE, DR, DZ, IC, QF, QP or QS.
4. In the MFG column, I added = "IS NULL"
5. I pressed the Run button; and here are the results:


So where did I go wrong?

Thank you for any assistance you can give me,

[JoeM]

If you want to return Null values for field MFG, just use:

Is Null

in your criteria.

The way you wrote it, since you put in between quotes, it is looking for a literal string that says "IS NULL".