first thread , i'm new ....
Goal : created a report based on a query. Query is based on multiple combo boxes where one combobox is updating another based on the selected value. Like : option 1 is depending on the selected truck. option 2 is based on option 1 and so on ..... that works.
In order to create a report based on all selected options, i'm trying to create a query. results of this query will feed the report.
It's not the purpose that all combo boxes have a selection and here is the problem**************
when one of the comboboxes have no selection, the query gives not a single result ( because of null value )
i'm able to change a null value into a empty value but then the query gives all possible results and this is no option.
combo boxes are from x multiple tables / queries
What i want is that the query neglect a combo box and move to the next combobox of the query if no selction is made.
final result should be a query output only with the comboboxes that have a value set / selection made ....
Goal : created a report based on a query. Query is based on multiple combo boxes where one combobox is updating another based on the selected value. Like : option 1 is depending on the selected truck. option 2 is based on option 1 and so on ..... that works.
In order to create a report based on all selected options, i'm trying to create a query. results of this query will feed the report.
It's not the purpose that all combo boxes have a selection and here is the problem**************
when one of the comboboxes have no selection, the query gives not a single result ( because of null value )
i'm able to change a null value into a empty value but then the query gives all possible results and this is no option.
combo boxes are from x multiple tables / queries
What i want is that the query neglect a combo box and move to the next combobox of the query if no selction is made.
final result should be a query output only with the comboboxes that have a value set / selection made ....
Attachments
Last edited: