Multi-Field Search Query not working, null data issue

[omair1051992]

I am facing issues when designing a query to filter out contacts from a table.

I designed a table full of contact details and a form to easily navigate that data. I made a separate search form [SearchForm] and a query [SearchQuery] that would filter out contacts according to the values entered in the search form. The query should filter contacts according to the fields filled in; the rest should be ignored.

I believe I may be facing an issue with null values but I cannot work it around (I do not know where and how to write expressions, etc, to solve the null value issue.

I have attached the database for analysis.

Thanks in advance!

 

[Guus2005]

Without having seen your database (due to security issues on my end) you can resolve the null-value issue by converting it to a number or a string using the Nz function.

For each value where you can expect the null-value you can use this function.

In a query:

select id, Nz(Desc,"") as Description from table1

HTH

 

[omair1051992]

Thanks a lot! I tried that and it worked.

 

[Guus2005]

You're welcome.
I am glad that it worked.