NZ Function in Access Query

[Rosier75]

Hello All,

Here's my question/issue. I have a form with 10 unbound text fields. Users will enter data into any combination of the fields to search the database and return the results. I created 1 query and under the criteria section for each appropriate field, I used:

Like NZ([Forms]![FormName]![TextFieldName],"*")

This seems to work properly however, when I compare the data the query is pulling versus what is actually in the table, I am coming up a few records short. Example, query pulls 96 records when searching by a specific field but there are actually 98 records. Additionally, when I do my comparison, I am actually using a 2nd query that prompts me to enter the specific data I am entering on the form. I believe the issue is with how I'm using the NZ formula.

Can anyone shed any light on this?

Thanks

[orange]

You may get some ideas from this free video tutorial. It's worth watching...
http://www.datapigtechnologies.com/f...earchform.html


Info on NZ https://www.accessforums.net/queries...ery-18462.html

[Rosier75]

Problem solved. My data table contained empty values in the various search fields which seems to throw off the NZ Function. Entered "n/a" for my empty values and query run as expected.