Help with query finding records with Nulls in them

[shenry16]

I have a table that in many of the fields there can be NULL values. I created a query on that specific table to use in a form where I send a parameter to one or multiple fields to filter my data. Problem is I cannot get the query to work correctly all the time on every field. Sometimes the record with NULL values gets returned and other times it does not.

Form:



Bug Product Risk Status Title AssignedTo

I have numerous records where Risk or Product or Status may be NULL for whatever reason. When I send in a parameter value for Bug the records with NULL in either of those fields doesnt get returned, but if there is a NULL in AssignedTo they are returned no problem. Attached is the query. Due to the data we contain I cannot submit the table view, but there is nothing different between any of the fields that I can tell. If more info on the query is needed please ask.

[llkhoutx]

Build your flter testing each filed being Nul, "OR"ing each field in the test, e.g.

isnull(field1) OR isnull(field2) . . . 

[shenry16]

I tried your solution likhoutx and although it didnt solve my problem it gave me an idea as far as doing the filtering dynamically instead of trying to use a query. Thanks for the thought provoking idea though. Much appreciated!!