sumif like func in access

Question

in my database some of my order value is CAP and other is DRF like

Allocation	Value
CAP	200
DRF	100
CAP	2000
CAP	1000

now i want a summation such that CAP & DRF Segregated, like CAP=3200, DRF = 100, TOTAL = 3300, WHICH I DO IN EXCEL with a use of sumif function, how can i do this in access.

Answer 1

SELECT

    SUM([Value]*IIF(Allocation="CAP",1,0)) AS TotalCAP,

    SUM([Value]*IIF(Allocation="DRF",1,0)) AS TotalDRF,

    SUM([Value]) AS OverallTotal

FROM [YourTableNameGoesHere];

Answer 2

A Group By query or use a Dsum()