1036
Chapter 38 Entering, Finding, and Filtering Data
This problem is almost always caused by a typo in a field name. Field names and parameters
both appear inside brackets. If you misspell a field name, especially in an expression used
with a calculated field, Access can’t find the field and therefore assumes you want to display
a parameter dialog box. Go through every expression in the query and see whether you can
find (and fix!) the typo.
Cleaning Up After Expressions
I entered an expression to define a calculated field, and then chose Sum from the Total row. The
query displays the results correctly, but when I look back at the query’s design, I ...