ACC2000: Total Row Is Not Reset When Switching from Crosstab to Make-Table Query (209630)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q209630
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you are creating a query and you select Crosstab as the query type, by default, all the columns in the query design 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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Microsoft Access and open the sample database Northwind.mdb.
  2. In the Database window, click Queries, click New, and then click OK to create a new query in Design view.
  3. In the Show Table dialog box, on the Tables tab, select Employees, click Add, and then click Close.
  4. Drag the EmployeeID and LastName fields from the field list to the Field row of the query design grid.
  5. On the Query menu, click Crosstab Query. Note that Group By appears in the Total row.
  6. On the Query menu, click Make-Table Query.
  7. Type a table name in the Make Table dialog box.

    Note that the Group By remains in the Total row.

REFERENCES

For more information about Make-Table Queries, click Microsoft Access Help on the Help menu, type create a new table from the results of a query with a make-table query in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For more information about Crosstab Queries, click Microsoft Access Help on the Help menu, type example of a crosstab query in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbprb kbusage KB209630
©2004 Microsoft Corporation. All rights reserved.