Access report

Hello,

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.
Database-Sample.accdb
Sample-report-format.docx
dnt2009Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
als315Connect With a Mentor Commented:
Look at sample. I've added summary status (TStatus in Query1), where each symbol means status of Option (options are added from right to left for sorting)]
Database-Sample.accdb
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.