When sub-query is used in the FROM clause, it can be viewed as selecting data from a virtual table because the result set of the sub-query is temporarily stored in memory and then used by the outer query as a table.
The query below is the inner query we just saw which shows a list of distinct values in the Reports To column.
Example: In Auto Exec macro, Set Temp Var named Licensed To to "Acme Corporation", and add this text box to each report header: =[Temp Vars]!Throughout its history, MDAC has been the subject of several security flaws, which led to attacks such as an escalated privileges attack, although the vulnerabilities were generally fixed in later versions and fairly promptly.The current version is 2.8 service pack 1, but the product has had many different versions and many of its components have been deprecated and replaced by newer Microsoft technologies. The latest version of MDAC (2.8) consists of several interacting components, all of which are Windows specific except for ODBC (which is available on several platforms).Get up to speed with Access 2007: These observations are limited to Access, and do not address very significant new capabilities for data collection and integration with other software through WSS (Share Point) or other software. Parameter shown as number (ASCII value) instead of text on a report. Stored procedure executed multiple times when opening a form/report. Navigation Pane and Status Bar issues after applying Service Pack 2. Templates disappear (with Spanish MUI on Win XP/2003)3.If you are upgrading from Access 97, you will also need the information in article, Converting from Access 97. Unable to link Sybase database if File DSN contains spaces.(This hotfix is also in Office 2007 Cumulative Update for August 2010) If you are familiar with older versions, the new Access may leave you shocked and bewildered - unable to find a thing without the familiar menus, toolbars, and Database window. Once you recover, you unearth some seriously useful new functionality beneath that pretty face: Create a template database to be used any time you create a new database.