<div>
are all fields using same criteria <b>where [Type]=&quot;Football Account&quot;</b>?<br />
if yes, then just have select sum(balance) from...group by...<br />
if not, then you must use a iif() function, like iif([Type]=&quot;Football Account,[Balance),0), then do a sum of that calculated field.
</div>


are all fields using same criteria where [Type]="Football Account"?
if yes, then just have select sum(balance) from...group by...
if not, then you must use a iif() function, like iif([Type]="Football Account,[Balance),0), then do a sum of that calculated field.

SteveL13

<div>
@Steve,<br />
did you tested my suggestion?
</div>


<div>
I didn't know how to work with your suggestion. &nbsp;Pat's suggestion worked out for me.
</div>


I didn't know how to work with your suggestion.  Pat's suggestion worked out for me.

<div>
<blockquote>
Pat's suggestion worked out for me.
</blockquote>
what?! can you please explain how did that helped...
</div>


> Pat's suggestion worked out for me.

what?! can you please explain how did that helped...

<div>
<div class="content wysiwyg-content">
I'm trying to sum values in query designer using certain criteria. &nbsp;Here is what I have so far but isn't working:<br />
<br />
Account: [Balance] where [Type]=&quot;Football Account&quot;<br />
<br />
<br />
I have several other fields to capture in the query which is why I need to do it this way.
</div>
</div>


I'm trying to sum values in query designer using certain criteria.  Here is what I have so far but isn't working:

Account: [Balance] where [Type]="Football Account"


I have several other fields to capture in the query which is why I need to do it this way.

How sum values in query designer using certain 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.