Hi All,
I want to be able to show codes which a parameter cannot find in a table, but I can't figure out the formula to do it.
Example: In a table under the CODE column are 6 codes AAA, BBB, CCC, DDD, EEE & FFF.
In my report I have a parameter promting for codes to search for. When prompted I enter the codes AAA, BBB, CCC and GGG.
I need the formula to say "Codes not found: GGG".
Anyone know how?
Best Regards to all.
Roger
I want to be able to show codes which a parameter cannot find in a table, but I can't figure out the formula to do it.
Example: In a table under the CODE column are 6 codes AAA, BBB, CCC, DDD, EEE & FFF.
In my report I have a parameter promting for codes to search for. When prompted I enter the codes AAA, BBB, CCC and GGG.
I need the formula to say "Codes not found: GGG".
Anyone know how?
Best Regards to all.
Roger