Empty parameter in a query

  • Thread starter Tiziana Venturini
  • Start date
T

Tiziana Venturini

On a form I have 3 combobox that contain the parameters for my query.
The user can select all the values or only one value or only two values.

Obviously the result changes every time
How I can construct the SQL string that it takes only the selected values
and it ignores the null values?

Thanks in advanced
Tiziana Venturini
 
Top