By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,729 Members | 1,490 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,729 IT Pros & Developers. It's quick & easy.

can update query or whatever make this possible?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.