How can i express the percent margin in a query for Microsoft Access?
Access 2000, Microsoft Access
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 ?
