I wanted a way in Design View to show some special instructions for running the query. This way worked for my needs.
I created a table with short field name descriptions, but no actual data:
INSTRUCTIONS
For Plan_1 column
add the plan name
to the Criteria and
if that plan is XYZ
be sure to add
XX422 to the
Brand_Name criteria
I then just outer-linked one of its field from a text field of another table in the query.
I created a table with short field name descriptions, but no actual data:
INSTRUCTIONS
For Plan_1 column
add the plan name
to the Criteria and
if that plan is XYZ
be sure to add
XX422 to the
Brand_Name criteria
I then just outer-linked one of its field from a text field of another table in the query.