Any problems with nested expressions?
Posted on 2014-01-31
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.