Having field in report change based on another field

[Kozbot]

Hello

I have a report that is looking up min and max quality specifications for a product. The table with the specifications has a Yes/No check box field for when the specs are defined as "Internal". So the table looks like Product/MinValue/MaxValue/Internal

I want the report to display "TEST AND RECORD" when the Internal box is checked where the MinValue and MaxValue (that are stored in the table) would be displayed otherwise.

Is this easily achievable? Thank you!

 

[plog]

Is this easily achievable?

Depends on your skill level. Is the [Internal] field part of the data source that the Report is built on? If so, you need to add a box and have the Control Source of it be this:

=Iif([Internal], "TEST AND RECORD", [MaxValue])

That will handle the MaxValue field, add another for the MinValue. If your Report's data source doesn't have the [Internal] field as part of it--get it. That means building a query or editing the one you currently have.

 

[Kozbot]

Depends on your skill level. Is the [Internal] field part of the data source that the Report is built on? If so, you need to add a box and have the Control Source of it be this:

=Iif([Internal], "TEST AND RECORD", [MaxValue])

That will handle the MaxValue field, add another for the MinValue. If your Report's data source doesn't have the [Internal] field as part of it--get it. That means building a query or editing the one you currently have.

I can do this

This will let the report return the values stored in the table (in the Min and Max fields) if the Internal field is not checked, correct?

 

[plog]

It's easier to post that question and wait for an answer, than see for yourself?