Thank you Doug,
I had tried that. I've discovered the problem was I was not defining the result as an expression (but as an aggregation).
I ended up with Format(Sum([Field]),"#,###"). So, the aggregation is within the expression and the query field is defined as an expression.
Last edited by lguzman01; May 27th, 2016 at 06:41 AM.