====================================================================== Microsoft(R) Product Support Services Application Note (Text File) WX0640: REPORTING QUESTIONS & ANSWERS ====================================================================== Revision Date: 10/92 No Disk Included The following information applies to Microsoft Access(TM) version 1.0. -------------------------------------------------------------------- | INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY | | ACCOMPANY THIS DOCUMENT (collectively referred to as an | | Application Note) IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY | | KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO | | THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A | | PARTICULAR PURPOSE. The user assumes the entire risk as to the | | accuracy and the use of this Application Note. This Application | | Note may be copied and distributed subject to the following | | conditions: 1) All text must be copied without modification and | | all pages must be included; 2) If software is included, all files | | on the disk(s) must be copied without modification [the MS-DOS(R) | | utility DISKCOPY is appropriate for this purpose]; 3) All | | components of this Application Note must be distributed together; | | and 4) This Application Note may not be distributed for profit. | | | | Copyright 1992 Microsoft Corporation. All Rights Reserved. | | Microsoft and MS-DOS are registered trademarks and Microsoft | | Access and Windows are trademarks of Microsoft Corporation. | -------------------------------------------------------------------- 1. Q. Why is every other page of my report blank? How can I correct this problem? A. This problem commonly occurs when the width of your report combined with the left and right margins is greater than the width of your paper. Adjust the width of your report and the margins so that your report fits on the page. 2. Q. How can I convert a form to a report? A. To convert a form to a report, open the form in Design view and choose Save As Report from the File menu. 3. Q. How can I sort the data in a report by a column in a separate table? A. To sort report data by a column in a separate table, create a query that includes the column from the other table, sort the column, then base the report on the query. If you have already created the report, verify that the query includes all the fields used in the report and change the Record Source property of the report to refer to the new query.