Hello Dear Friends
I have a table with ProductSale field and its Type is Number and Format is #,###.... When I use a Query with this field along other fields, its show the values like this 123,165 But when I want to get SUM of ProductSale... it show values without COMMA... I tried this line in query Expr2: Format(Sum[ProductSale],"#,###")) but not values come WithOut Comma.... please guide how to get values with Comma in SUM field or in Crosstab Query... I need SUM of ProductSale with Comma.....
Thanks
Irsmalik