Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link