Subqueries are SQL (structured query language) statements that database users nest within other SQL statements. Subqueries enable users to produce data for a report, often from at least one table that’s different from the main query’s table. For example, a query listing all store products that have reached their weekly sales quota may be written like this: SELECT [Product], [SalesQuota] FROM [ProductsTable] WHERE [SalesQuota] < ALL (SELECT [Sales] FROM [SalesAssociates] WHERE [SalesAssociates].[Product]=[ProductsTable].[Product]); Microsoft Access, via its subreports features, offers at least two methods for adding subqueries to reports. With subqueries, Access users can produce reports whose detailed data clarify the data in the main reports. Writer Bio
