How to Write Subqueries MS Access

Quick summary

Writing subqueries in MS Access lets you nest one SQL query inside another to filter or compute data more precisely. This tutorial walks you through opening the SQL View, entering a subquery, and running it directly in Microsoft Access.

Steps

1. Open your Access database.
2. Right-click on the query you want to open and select SQL View.
3. Enter your subquery in the empty SQL field.
4. Click Run to execute the query and see the results.