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

• 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 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.

Keywords : kbusage QryTotal
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb