Queries can include summary or detail information but they cannot create both at the same time. If you want a detail list with totals, you'll need to create a report. If you want only summary info, you can do that in the query directly by creating a totals query.
1. Create a new query.
2. Select the table or query that you want to summarize.
3. Select the colums you want.
4. Press the sigma button to change this to a Totals query. A new line will be added to the grid with the value "group by" for the total field.
5. Leave "group by" for the identifying columns that the amounts will be summarized to such as product and name. But change the value to Sum for the price field.
6. Save the query and run it.
