sum functions

[trippers]

I have a table with the following columns and rows:



Item Quantity Price Amount
Pencil 1 9.00 9.00
Pencil 1 8.50 8.50
Pencil 1 9.00 9.00


I wanted make a report like this:

Pencil 2 9.00 18.00
Pencil 1 8.50 8.50

How do I make a query that the result would be my desired report? Is this possible?

[NTC]

You want to use an 'aggregate' query which is offered, while in query design view - look for the epsilon icon (greek E).... experiment with the groupby. Presuming you have a textbook - these all cover this common type query.

[trippers]

Thank you.. I got it. I use "Group by" on the prices.