Getting Winners and Losers stats with two iif(<condition>) clauses in a single query

[EricRex]

Solved my own problem from Google hints.

My values weren't being rounded in the form because they were being treated as strings, which is bizarre because they're all aggregate values coming straight from the Saved Parameter Query. I suppose they're treated as Variant in VBA and the form doesn't care what it is?

Anyway, changed the population equation to = CSng(.Fields(fieldnum).value) and it works like a charm.

Thanks for the hint!

I did wonder about your comment on saving 20-30% of the calculations without the Round. Thinking that the Round still must be performed, but it's done by the Form instead of the Query. Can't imagine there's a big time differential between those two. I would hope both are super optimized and computationally cheap.

Cheers,
Eric

[CJ_London]

No need for .value as it is the default property

[EricRex]

Not sure where you get stDevP from - perhaps a later version of Access or you have a public function, I only have stDev

I'm using Access 2021 Desktop version.