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

Sum a Total Dollar amount within a specific group

P: 58
Sorry, this is a duplicate. Please reply the other one

Part of my Access Database has two fields that I want to work on: [Model] and [Gross]
[Model] has a drop down list with ( "A", "B", "C", etc,) options.

When I use the following expression, (in this case for Model “A”)
Code.
Abs(Sum([Table].[Gross] And ([Table].[Model]="A"))) AS [Total A Gross]

I get the count of the number of records that the Model "A" has, which is 2. Instead, my intension is to get the total Gross amount of it, which is $350.00.

Model……Gross……Gross A
A…………150.00…..…….1
A……….. 200.00.………..1
B………..375.00.…………0
C………..400.00...……...0
C……..…100.00………...0
Total……………………….2

What would it be the correct expression to get the Total Gross of each Model individual?

Something like this would be the ideal Query:

Model……Gross……Gross A……Gross B……Gross C
A…………150.00……..150……….…0……………..0
A………. 200.00………200………….0……………..0
B……….375.00………..0…………375……………..0
C……… 400.00………..0………….0……………..400
C………100.00………..0………….0……………..100
Total………………….…350………..375…………….500

If anyone can help me on this, will be greatly appreciated

plaguna
Jan 19 '09 #1
Share this Question
Share on Google+
2 Replies


P: 58
This is a duplicate thread. Deleted by Plaguna
Jan 19 '09 #2

NeoPa
Expert Mod 15k+
P: 31,494
Is http://bytes.com/topic/access/answer...o-fields-query the other version you're referring to?

If you confirm which it is I can close this thread to further posting for you.
Jan 20 '09 #3

This discussion thread is closed

Replies have been disabled for this discussion.