How Do I Design a Report That Gives Me Data From Several Different Microsoft Access Queries?
Design a report that gives you data from several different Access queries by nesting sub-reports for each query within a main report. Microsoft Access provides several controls, which are used to add images, labels, buttons, lines, check boxes, option buttons, sub-forms or sub-reports and charts to reports. The subforms/subreports control wizard, which launches from the Design ribbon in Access, will step you through the process of creating sub-reports from any query or table for use in your main report. Open Microsoft Access. Click the “Office” button. Select “Open” from the menu. Highlight the database file that you want to open. Click the “Open” button. Click on “Create.” Select “Blank Report” from the “Reports” group. Right-click on the report. Select “Design View” from the menu. Click on the “Subform/Subreport” control in the “Controls” group of the “Design” tab. Click with the right mouse button in the area of the report to add the sub-report. Select the radial button beside “Use
