Hi everyone,
i am facing a simple problem but too difficult for me. i am trying to devlop a assets maintenance application. i have a table named assets consisting of fields named acquiredquantity, acquiredprice, salequantity and salevalue. assets table also contains one field departmentID which contains the name of department to which the asset belongs. i want a report which contains only the current quantity and current value of the asset i.e.
current quantity = acquiredquantity-salequantity
current value =acquiredprice-salevalue
Report is sorted on the basis of departmentID
Is it possible to do it, i don,t want the four fields on which calculations are done to be shown?
sunil
i am facing a simple problem but too difficult for me. i am trying to devlop a assets maintenance application. i have a table named assets consisting of fields named acquiredquantity, acquiredprice, salequantity and salevalue. assets table also contains one field departmentID which contains the name of department to which the asset belongs. i want a report which contains only the current quantity and current value of the asset i.e.
current quantity = acquiredquantity-salequantity
current value =acquiredprice-salevalue
Report is sorted on the basis of departmentID
Is it possible to do it, i don,t want the four fields on which calculations are done to be shown?
sunil