Use a subquery as a field alias when you want to use the subquery results as a field in the main query. A subquery that is used as a field alias cannot return more than one field.
To download example MS Access file please click on the link below
https://www.findeasysolution.com/Down...