Hello,
I have the table shown below. Col1 is selectable 1-4. Field5 is selectable "Open" or "Closed". I can make a query that finds the Field5=Open. How do I make a report that shows only items that are "Open", and then if Col1=1, it shows only Field1, if Col2=2, it shows only Field2, etc? So each line of the report has ID and then only one of Field1,Field2,Field3,Field4 depending on Col1 selection. Thank you.
I have the table shown below. Col1 is selectable 1-4. Field5 is selectable "Open" or "Closed". I can make a query that finds the Field5=Open. How do I make a report that shows only items that are "Open", and then if Col1=1, it shows only Field1, if Col2=2, it shows only Field2, etc? So each line of the report has ID and then only one of Field1,Field2,Field3,Field4 depending on Col1 selection. Thank you.