Hi,
I have a a table with 10 columns.
I have put 10 parameters in it, one for each column
I have done the : like [parameter name] is null in the OR expression for
each field.
However this does not work.
If I enter non null for the first parameter and leave blank for the others, it will return the records for field1 with the parameter value but also return all the records that have nulls in the other fields.
I want to create a query that no matter what combination of non-null parameter values and null values fed to the 10 parameters I will always
get the records filtered down correctly.
I suspect this would need to be done using a sub procedure in VBA that would dynamically build the query by parsing together snippets of sql together until the correct SQL statement existed. Would this be right or can it indeed be done in just SQL?
Thanks
Haggisns