<div>
It's been while since I worked on MS-Access, but is something like following possible?<br />
<br />

<pre><code id="code-20-42057010-1">select activityId, sum(iif(column2 = &quot;R&quot;, column4, 0)) sum1
from table_name
 </code></pre>
 <br />
<br />
If yes, you can derive formulas on similar lines. And add group by of course!
</div>


It's been while since I worked on MS-Access, but is something like following possible?



select activityId, sum(iif(column2 = "R", column4, 0)) sum1
from table_name
 



If yes, you can derive formulas on similar lines. And add group by of course!

<div>
<div class="content wysiwyg-content">
I have a data set of <br />
column 1 = activity ID<br />
column 2 = accepted/rejected (value is either &quot;R&quot; or &nbsp;&quot;A&quot;)<br />
column 3 = accept (value is either &quot;A&quot; or left blank)<br />
column 4 = sum of hours (numerical value of hours)<br />
what I need is to generate a sum with one or more criteria for the activity ID<br />
sum 1 = sum of hours where column 2 = &quot;R&quot;<br />
sum 2 = sum of hours where column 2 = &quot;R&quot; and column 3 = &quot;A&quot;<br />
sum 3 = sum of hours where column 2 = &quot;R&quot; and column 3 = blank or null
</div>
</div>


I have a data set of 
column 1 = activity ID
column 2 = accepted/rejected (value is either "R" or  "A")
column 3 = accept (value is either "A" or left blank)
column 4 = sum of hours (numerical value of hours)
what I need is to generate a sum with one or more criteria for the activity ID
sum 1 = sum of hours where column 2 = "R"
sum 2 = sum of hours where column 2 = "R" and column 3 = "A"
sum 3 = sum of hours where column 2 = "R" and column 3 = blank or null

access query with one or more criteria

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.