At 08:17 PM 3/8/01, Satish Mehta wrote:
>Hello everyone!
>I have a data-item 12345 and another data-item -23456. I would like to see
>the result as 123.45 Currently I am using edit mask as ZZZZZZZZZ9. If I
>use edit mask as ZZZZZZZZ.99 I get the result as 12345.00. If I use edit
>mask as $$$$$$$$.99 I still get the same result (with a $ sign in front).
>Can some expert suggest to me what edit mask to use to get desired
>results. Also How can I get "-" sign as first character (e.g. -234.56)
>when the item value is -ve? TIA
>-Satish Mehta
If you haven't done so already, check the data item being edited to make
sure it's a numeric type. I've seen QUERY produce some strange results when
a numeric edit mask is applied to an alphanumeric item (type X or U).
Also, I don't believe QUERY supports a leading minus sign. You may have to
settle for a trailing sign.
Good luck with your project!
Joe Berliner