displaying a positive value in form
I have got a table tblshipping which has got two col named as send_qty,received_qty from where i calculate the quantity.
the thing is some times in the calculation i get a negative value and some times positive i want always the positive value should be displayed to end user
SQL>select sum(send_qty) - sum(received_qty) from tblshiping where matid='1';
i will get say some thing (-5)
in the fom i want to display this (-5) as (5) ....can any1 help me out how this is possible.....
I know changing the order in the query it can be done but again for some condition it will display negative value which i dont it to display