![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
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.
