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
1031
Using Queries to Extract Data from a Database
Defining Criteria
Any expressions you enter in the Criteria row instruct Access to show only those records
that satisfy the criteria. These expressions can be extremely simple: >10, for example, tells
Access to display all records in which the value of the selected field is greater than 10. You
can combine multiple criteria in a single column or across multiple columns, using the fol-
lowing logical rules:
Expressions in multiple columns in a single row are treated as And criteria. To be
selected as part of the query’s results, a record must meet all the criteria in a given row.
Expressions in different ...
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