FastTips: Reports Questions & Answers

PSS ID Number:  Q100849
Article last modified on 08-27-1993

1.00 1.10
WINDOWS

======================================================================
  Microsoft® Product Support Services Application Note (Text File)
                  WX0640: REPORTS QUESTIONS & ANSWERS
======================================================================
                                                   Revision Date: 5/93
                                                               No Disk
The following information applies to Microsoft Access, version 1.0
Copyright 1992-1993.
 ---------------------------------------------------------------------
| 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®  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-1993 Microsoft Corporation.  All Rights
Reserved.|
| Microsoft, Microsoft Access, and MS-DOS are registered trademarks
|
|         and Windows is a trademark of Microsoft Corporation.
|
|   This document was created using Microsoft Word for Windows™.
|
 ---------------------------------------------------------------------
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 field not displayed on
       the report?
    A. To sort report data by a field in a separate table, create a
       query that includes the field from the other table, 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 RecordSource property of the report
       to refer to the new query. Now you can adjust the Sorting and
       Grouping properties of the report to sort on the new field.

Additional reference words: 1.00 1.10 ivr ivrfax fasttips
KBCategory:
KBSubcategory: