I am working on a database where a list of items is created in a table. These items can be used in different options.
I need to run a report with shows the status of the items and the list of Items for each option selections (multiple options may be selected).
I have attached a sample file of my table, query and report and a sample of the report format which I am trying to achieved.
Many thanks for your help.