can update query or whatever make this possible?

[Paul T. RONG]

Hello all,

I have a problem, wishing somebody can help, this is the case, in the table
order_detail:

ProductNumber price quantity

001 1.00 5
002 2.00 3
003 2.50 2
002 2.00 1
003 2.50 1

what should I do if I want to see it like:

001 1.00 5
002 2.00 4
003 2.50 3
Many thanks in advance,

Paul

[Salad]

Paul T. RONG wrote:

Hello all,

I have a problem, wishing somebody can help, this is the case, in the table
order_detail:

ProductNumber price quantity

001 1.00 5
002 2.00 3
003 2.50 2
002 2.00 1
003 2.50 1

what should I do if I want to see it like:

001 1.00 5
002 2.00 4
003 2.50 3
Many thanks in advance,

Paul

Click Query/New/Design. Add your OrderDetail table and hit close. Now
drag the 3 fields down. From the menu click View/Totals. In the totals
row set the productid and price to groupby and sum under qty. Run it
and see if that does what you want.