Don't understand that.
None of the records have any blank fields.
Okay, two query objects with the same filter criteria. What exactly is not working?
You want the filter criteria to include ALL of the parameters or do you want to allow user to be able to select any combination of parameters?
I am guessing from your images you want the latter. If your parameters where all for text fields, the use of LIKE operator and wildcard would work. Review
http://www.datapigtechnologies.com/f...mtoreport.html
Since some of your parameters are not for text fields, LIKE operator and wildcard will not work (except it does work on Yes/No field). Would have to provide alternate values if the search controls are left blank.
AND AddStockQ.ReceiveDate Between Nz([forms]![IncomingStockStatusF]![StartDate], #1/1/1900#) And Nz([forms]![IncomingStockStatusF]![EndDate], #12/31/2900#)