Sum only unique records

[phillipmai]

Hello,

How can I sum Field B if Field A is unique.

For example:

Field A Field B
1 12
1 12
1 12
1 12
1 12
2 13
2 13

Sum of field Field A = 12 and sum of Field B = 13

Hope someone can help!

Thanks.

 

[vbaInet]

Welcome to AWF

Have a look at these:

http://www.techonthenet.com/sql/sum.php
http://www.techonthenet.com/sql/distinct.php

 

[stopher]

I don't understand the question

Sum of field Field A = 12 and sum of Field B = 13

Do you mean you want the following output?:
Field A____Sum Field B
1___________12
2___________13

You could arrive at the above result if you simply do an average.

But what would the result be for:

Field A__Field B
1_______10
1_______10
1_______12
1_______12
1_______12
1_______12
1_______12
2_______13
2_______13


Chris

 

[vbaInet]

Lol I found that hard to understand too Chris. Which was why I gave links for both possible outcomes.

 

[phillipmai]

Sorry!

I should have read what I typed before posting.

Stopher was right I need the output:

Field A____Sum Field B
1___________12
2___________13

And not Sum of field Field A = 12 and sum of Field B = 13 (which makes no sense)

 

[ByteMyzer]

Your request is still not clear. What exactly is it that you are trying to accomplish?

 

[boblarson]

Your request is still not clear. What exactly is it that you are trying to accomplish?

And to further question -

Why are there records stored like that and why are you trying to get the values like you are trying to get? What is the purpose of both?