Thread: Show records that contain Null Values

Hello all,

Thanks in advance, I have a dilema hopefully someone here can help shed some light on.

I have created a query by form in access 2010. Within the form I have several combo boxes and when the user selects a value from the combo box it fills in the text box next to it with the value just selected, now the query checks the Textbox and renders the criteria desired. No problem works great, until I added a column in the query that some records do not have values in.

Example of criteria I placed in the columns(cells) that all have values:

   IIf([Forms]![ProductInformationForm]![Text186] Is Null,[ProductDetails]![ProductPackageType],[Forms]![ProductInformationForm]![Text186])

This works great, like I said for the ones with values, but I have tried this same SQL in the column that not all records have values, and no matter what is selected on the form, the query shows no records.

Please help, thank you...

Can you post the entire query? I'm especially interested in the WHERE clause.