6.4. Query Power: Calculated Fields and Text Expressions
Every Access expert stocks his or her database with a few (or a few dozen ) useful queries that simplify day-to-day tasks . Earlier in this chapter, you learned how to create queries that chew through avalanches of information and present exactly what you need to see. But as Access masters know, there's much more power lurking just beneath the surface of the query design window.
In this section, you'll delve into some query magic that's sure to impress your boss, co-workers , and romantic partners . You'll learn how to carry out calculations in a query and perform some basic text manipulation (joining together first and last names , for example).