Thank you, that almost fixes it but not quite.

I want to be able to search on some of the fields, but not necessarily all.

But when I change it to "OR", it doesn't narrow it to specific year and value, for instance. It brings up all of one year and all of the value, not the ones that correlate to the year and value together.

If I have "AND" in the sql, it doesn't pull any if one field...

I've created an access 2010 form to run with a query that has the ability to search for data ranges in multiple fields. If I leave any of the boxes on the form blank, the query comes up with nothing.

I want to be able to search on all or some of the fields.

Here is the code. It only works if all the fields have values. Thanks for your help

WHERE ((([2009 Commercial Improved Database].Yr_blt)>=[Forms]![Commercial...