Hello Dear Friends
I have a table with ProductSale field and its 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...
Thanks
Irsmalik
I have a table with ProductSale field and its 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...
Thanks
Irsmalik