We have a report that has filter setup to only show record types of a certain kind. The syntax is [Record Type] in ('1','2','5'). Attached is a pic. The user is asking that it only show the Record Type of '5' when the company is 100. We have several companies in the data, 100, 200, and 300. So for Record Type '1' and '2' any company is ok but for Record Type '5' it should show the records for only company 100. How do we do this? Thank you in advance for your suggestions!
Maybe something like this:
(
[Company Code] = 100
and
[Record Type] in ( '1','2','5' )
)
or
(
[Company Code] <> 100
and
[Record Type] in ( '1','2' )
)
Thank you Lynn! That worked perfectly!