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

Gruop the data

P: 1
I have a table which contain data as in table below:
Product Code/Amount(dollar)
10/200
10/300
10/20
10/50
20/100
20/100
30/300
30/450
30/200
50/600
50/250
60/160
60/230
70/360
70/250
70/420
Total/3990

Where 10 & 20=cake
30 & 50=biscuit
60 & 70=muffin

I would like the output to be like in table:

Product/Subtotal
Cake/770
biscuit/1800
muffin/1420

I truly have no idea of how to get it through all in 1 query.
Much appreciated If any one have good suggestion of query or methods in Access to help me get the output. thanks
Aug 19 '08 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
Hello.

Please include the MetaData for all relevant datasets. Here is an example of how to post table MetaData :
Table Name=tblStudent
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; AutoNumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Kind regards,
Fish
Aug 19 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.