Report with multiple criteria (1 Viewer)

lneukirch

New member
Local time
Today, 13:30
Joined
Jul 31, 2020
Messages
2
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.

Untitled.png
 

June7

AWF VIP
Local time
Today, 10:30
Joined
Mar 9, 2014
Messages
5,423
Have expression in textbox that conditionally displays data. =Choose(Col1, Field1, Field2, Field3, Field4)
 

Isaac

Lifelong Learner
Local time
Today, 11:30
Joined
Mar 14, 2017
Messages
8,738
You can also rectify this at the query level, the query which underlies the report, with something like an IIF statement.
 

June7

AWF VIP
Local time
Today, 10:30
Joined
Mar 9, 2014
Messages
5,423
Yes, same expression can be used in query to calculate a field. Bind textbox to that calculated field.
 

lneukirch

New member
Local time
Today, 13:30
Joined
Jul 31, 2020
Messages
2
Thanks for the replies, they pointed me in the right direction.
 

Users who are viewing this thread

Top Bottom