Displays the results of your query as a report layout. This dialog box appears on the Miscellaneous tab of the Query Designer and is available only for queries. For more information, see Miscellaneous Tab, Query and View Designers.
Note: |
---|
You must have previously set up a report file (.frx) that accommodates the fields of output in the query. For more information, see Working with Reports. |
- Open Report
- Displays the Open dialog box for you to select a report file to use for your query. You can click the button or type the file name in the text box.
- Wizard Icon
- Displays the Wizard Selection dialog box, from which you can choose a report wizard to run.
- Page Preview
- Displays the output in the Page Preview window.
- Console On
- Displays the output in the active output window.
- Eject Page Before Report
- Prints a blank page at the beginning of the report to separate documents at the printer.
Secondary Output
- None
- Specifies that the output not be sent to the printer or saved as a text file.
- To Printer
- Sends the results of the query to the printer.
- To Text File
- Saves the results of the query as a text file. Click the button to select an existing file that you want to overwrite, or type the name of a new file in the text box.
Options
- Suppress Column Headings
- Keeps column headings from appearing at the top of the output.
- Summary Information Only
- Suppresses detail line printing. The report produced includes the headings, footers, totals, and so on, but excludes the detail lines.