ACC: Total Row Not Reset Switching from Crosstab to Make Table

 Last reviewed: May 28, 1997
Article ID: Q96456
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you choose Crosstab as the query type, by default, all the columns in the query by example (QBE) grid have Group By in the Total row. If you change the query type to Make Table, the columns still have Group By in the Total row.

CAUSE

When you change the query type, Microsoft Access removes the rows that are not allowed but displays the rows that are required and the rows that are optional. Because Make Table queries can include totals, the Total row remains the same.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).

  2. Create a new query.

  3. Add the Employees table.

  4. Drag the EmployeeID and LastName fields from the field list to the QBE grid. (In Microsoft Access 1.x and 2.0, drag the Employee ID and Last Name fields to the QBE grid.)

  5. On the Query menu, click Crosstab. Click the Total row, and click the arrow. Note that Group By appears in the list.

  6. On the Query menu, click Make Table.

  7. Type a table name in the Make Table box (or Query Properties box in versions 1.x and 2.0). Note that the Group By remains in the Total list.

Keywords : kbusage QryTotal
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.