Hi
I am making a investment porfolio database
I have a purchase table and seperate Category of Financial transaction table
,in financial transaction table i can choose a category of finan. Transaction which can be Reciept ( ie yes or no field).
What i want to do is sum quantity and amount on basis of reciept=yes and reciept=no and substract them from each other to get balance quantity and amount...how to i get to do this in best possible way,help is greatly appriciated
I am making a investment porfolio database
I have a purchase table and seperate Category of Financial transaction table
,in financial transaction table i can choose a category of finan. Transaction which can be Reciept ( ie yes or no field).
What i want to do is sum quantity and amount on basis of reciept=yes and reciept=no and substract them from each other to get balance quantity and amount...how to i get to do this in best possible way,help is greatly appriciated
