Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.3 Utilize Calculated Fields and Grouping Within a Query: Add Calculated Fields

Link the Query to the Form 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... Query Design Tools ->Design->Query Setup->Builder