I’m using Access 2013. I’m trying to search a query in 6 different fields. I’m using the “Like” feature in each field. If I only use 1 search field, it works fine. But, trying to search more than that brings up a problem. Access looks at the field and if it’s null, it disregards that field. So, searching for something in one field, the other fields also have to be populated or Access disregards it because it’s null. I need Access to look at all fields regardless of it being null. I was told that I need to use the Nz feature. I’m not sure how it works or if it will work. Any ideas?