Search query not returning all instances

[oneillp111]

I have a database for storing part numbers of power supplies, very basic database. I also have a multifield search form and search query. All very basic stuff, however I am new to access and cannot seem to find out what the is causing this issue.



There are 174 entries in the database table, they all start with "0" for the part number, I have wild cards in my Query so that for instance if I searched 0 for the part number field, it should return all 174 entries, but for some reason it only returns 49 entries. I have attached the database as an example. Any help would be great!

Thanks

[lfpm062010]

It looks like you are not picking up all the fields that have NULL value.
The solution is not as simple as just use "OR IS NULL" in the criteria. You might pick up more records than you need.

Program in VBA should solve your issue.