# How to Write Subqueries MS Access

> To write subqueries in Microsoft Access, open your database, right-click the desired query, and select SQL View. Enter your subquery in the empty field, then click Run to view the results.

Canonical: https://livedemo.ai/tutorials/how-to-write-subqueries-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a52ddab56e05a000002a9/preview?step=1

## 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 field.
4. Click 'Run' to see the results.