|
A Query
can look up a Field on a Form and use that data to select
records that match. We'll use
the Expression Builder to select the Rating on the
MovieSearchForm and add it to the Rating Criteria in RatingSearchSQ.
7.
Try it: Find the Expression Builder
RatingSearchSQ is open in Design View. Go to the
Rating Field. Delete the
Criteria: Is Not Null.
Right-click the Criteria. Select an
Option: Build. Keep
going...
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.3. Manipulate fields: Use the
Expression Builder
Query Design Tools
->Design->Query Setup->Builder |
|
| |
