You can use subquery as a field criteria. Use a subquery as a field criteria when you want to use the result of the subquery to limit the values that the main query displays. You can use any number of subqueries to limit values displayed by main query.
To download example MS Access file please click on the link below
https://www.findeasysolution.com/Down...