How can I format a character field that is displaying numbers to use commas as thousand separators? I'm trying to use TRANSFORM() with a format code of '###,###,###' but am getting commas in the wrong places. Thoughts anyone?