Query only retrieving certain data records...

J

jimswinder

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?
 
B

BruceM

In the combo box property sheet, click the Data tab, then click Row Source,
then click the three dots that appear at the right side of the property
sheet in that row. Be sure that every field with a something listed in the
Criteria row also has Is Null in the Or row, unless of course a particular
field needs to be there, in which case omit Or Is Null.
If it still doesn't work, post the Row Source SQL (when you have opened the
Row Source query, click View > SQL, then copy and paste what you see into a
message).
 
J

jimswinder

ok..got it to work...had to add "or is null" to tthe end of the formula...

Thanks Bruce!!! :)
 
B

BruceM

Great! Good to hear that it worked. I remember now that I don't always get
the results I need when I use Is Null in the Or box, but that it works at
the end of the criteria expression. Curiously, when I go back and look at
the query it has broked Is Null from the criteria and placed it in the next
row. Something is going on that I don't quite get.
 
Top