comparing a value to a list

D

dgkra

Trying to filter a report by comparing a field value to a list without having
to retype the table name and field everytime - the following works:
[Payments Applied with Groupings Added]![P/A Mess Code 1
Grouping_Grouping]="Additional Information" or
[Payments Applied with Groupings Added]![P/A Mess Code 1
Grouping_Grouping]=" Bundling/Mod/CPT"

But isn't there a way to compare the table/field name to "additional
information" and "bundling/mod/cpt" without completely reentering the
table/field name everytime. I've tried seperating with semi-colons etc and
can't get the syntax correct.
 
Top