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


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
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.

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.
Modification Type:MajorLast Reviewed:5/28/2003
Keywords:kbprb kbusage KB96456
©2002 Microsoft Corporation. All rights reserved.