P
peljo via AccessMonster.com
How can i express the percent margin in a query? I have a field PurchasePrice
and a field Salesprice. the field Purchaseprice is the price at which we buy
the products and the field salesprice is the field at which we sell the
products.I tried to substract the salesprice to the pruchase price and divide
the difference with the salesprice.
Am i right and why the result in the query is not in percentage ?
and a field Salesprice. the field Purchaseprice is the price at which we buy
the products and the field salesprice is the field at which we sell the
products.I tried to substract the salesprice to the pruchase price and divide
the difference with the salesprice.
Am i right and why the result in the query is not in percentage ?