<div>
<div class="content wysiwyg-content">
Hello - is there a hard &amp;&nbsp;fast rule about nested expressions in Access (2010) queries, like: <br />
Sum(1) As CountOfTotalTickets, Sum(IIf([Hours] &gt;&nbsp;0,1,0)) As CountOfTicketsWithHours, [CountOfTicketsWithHours]/<wbr />[CountOfTo<wbr />talTickets<wbr />] As PctTicketsWithHours<br />
<br />
I know I could do this in a single expression, but this is just one simple example from a large set of qry's I have to work up where it gets more complicated than this.<br />
<br />
Also, I'm trying to structure these qry's in a way that I can pull them up in datasheet view and demo that the math is being done correctly (a &quot;show your &nbsp;work&quot; kind of thing)<br />
<br />
On occasion, I have done this with no problems, and other times, it would get flaky on me. &nbsp;<br />
<br />
Thanks
</div>
</div>


Hello - is there a hard & fast rule about nested expressions in Access (2010) queries, like: 
Sum(1) As CountOfTotalTickets, Sum(IIf([Hours] > 0,1,0)) As CountOfTicketsWithHours, [CountOfTicketsWithHours]/[CountOfTotalTickets] As PctTicketsWithHours

I know I could do this in a single expression, but this is just one simple example from a large set of qry's I have to work up where it gets more complicated than this.

Also, I'm trying to structure these qry's in a way that I can pull them up in datasheet view and demo that the math is being done correctly (a "show your  work" kind of thing)

On occasion, I have done this with no problems, and other times, it would get flaky on me.  

Thanks

Any problems with nested expressions?

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.