Microsoft KB Archive/209630

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

Article ID: 209630

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.

