Subtotals within a query

[mulefeathers]

I have a query that is looking at sales orders. Is it possible to add a sub-total to a query?

Example:
My query returns sales_date, part number, QTY, and Dollars.

There are many sales orders with the same part number but differnet qty and dollars.

Sales Date | Part number | QTY | Dollars |
06/15/2010 | 1234 | 5 | 100 |
06/07/2010 | 1234 | 10 | 200 |
06/10/2010 | 1234 | 15 | 300 |

And so on..

What I need to be able to do is total the dollars pbased on the change in part numbers.

can I do this in this query and if not how should I do it?

Thanks

[kimmer]

Remove Sales Date and QTY.
Group by Part Number, Sum Dollars:

Click the Totals button --it looks like Excel's Autosum button. This creates a Totals row in the grid. Edit the Totals cell in the Dollars field so it is SUM instead of GROUP BY.

[mulefeathers]

Remove Sales Date and QTY.
Group by Part Number, Sum Dollars:

Click the Totals button --it looks like Excel's Autosum button. This creates a Totals row in the grid. Edit the Totals cell in the Dollars field so it is SUM instead of GROUP BY.

Thanks for your help.