Microsoft KB Archive/96456

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

Article ID: 96456

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q96456



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



SYMPTOMS
When you are creating a query and you select 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 then 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.



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: kbprb kbusage KB96456

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.