Query not picking up null values

[Ben2k]

Hi,

I have a query which includes the following

Feild: Part Number
Table: SERVWORK
Criteria:
<>"num" And <>"perf" And <>"sun" And <>"mag5w30" And <>"sublet" And <>"mag10w40" And <>"slx" And <>"syntrax" And <>"anti" And <>"dexron iii"

It works fine UNLESS the part number is blank, i.e. null in that case the query excludes that record.

How can I fix it?

Thanks

 

[Cbrine]

Ben2K,

I would suggest that you change your criteria field to a custom field like this.

Part Number1: Nz(Part Number)

This will convert all your null fields to blanks instead(or zero's can't remember which)

HTH
Cal