fuzzygruf: (sudoku)
2015-08-20 07:59 am
Entry tags:

Add a comment to MS Access Query in Design View

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:
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.