- Create a query using the wizard based on the movies table
- Click on Queries on the left hand side of your screen
- Then, click on Create Query using Wizard.
- Select the Movies table and select ALL fields EXCEPT Director to be included.
- Click Next
- Sort by Movie Title in DESCENDING order
- Then, click on MATCH ALL OF THE FOLLOWING
- Choose Total Gross as the Field, Is Greater Than for the condition, and type in 100,000,000 for the value. (This will filter movies that only made more than $100 Million)
- Click Next
- Choose Detailed Query
- Leave the aliases as is
- Name the Query "Income Query, then select modify query
- Click Finish
Nov 3, 2008
Movies Database - Part 3 (Queries)
Today, you will be creating a query based on the movies table that you created.
