Query only retrieving certain data records...

[Guest]

I am using a Combo Box with a drop down list as one of my field criteria.
Problem is, it only retrieves records that have data in every field. How do I
tell it to retrieve all records that meet a criteria, even those records that
have "null" values in some of the data fields?

 

[BruceM]

Try adding "Is Null" (without the quotes) to the Or row in your query design
grid.

 

[Guest]

nope...didn't work. :-(

Try adding "Is Null" (without the quotes) to the Or row in your query design
grid.