I've been searching the answer for the whole day, and wont be able to find my answer. Thanks for your help in advance! I'll get straght into it.
My Dataset:
ColunmA ColunmB Value
a b 1
b d 2
a q 3
c a 5
b e 2
d e 10
f q 1
q m 8
. . .
. . .
. . .
In Excel, I would do sumif( ColunmB,a2,Value), which gives me a result:
ColunmA ColunmB Value Result
a b 1 15
b d 2 2
a q 3 15
c a 5 8
b e 2 2
d a 10 2
f b 1 0
q c 8 0
. . . .
. . . .
. . . .
So based on each string in ColunmA, it would search all ColunmB and return an aggregated value.
How can i get the same result by Access/SQL query?
Regards,
Michael
PLS Help!! Sumif formula in MS Access
My Dataset:
ColunmA ColunmB Value
a b 1
b d 2
a q 3
c a 5
b e 2
d e 10
f q 1
q m 8
. . .
. . .
. . .
In Excel, I would do sumif( ColunmB,a2,Value), which gives me a result:
ColunmA ColunmB Value Result
a b 1 15
b d 2 2
a q 3 15
c a 5 8
b e 2 2
d a 10 2
f b 1 0
q c 8 0
. . . .
. . . .
. . . .
So based on each string in ColunmA, it would search all ColunmB and return an aggregated value.
How can i get the same result by Access/SQL query?
Regards,
Michael
