Percent markdown caluclation on datasheet
Posted on 2011-02-23
I have a datasheet form that I need to do some calculation on, the control source is a query qryEdit. There is a SellingPrice which has a value in it, a ShowPrice which will be a minus percentage of the SellingPrice column. For example if the sellingPrice is $100 and the Showprice is -10% of the sellingPrice , the value in the Showprice would be $90.00. I would like to have the user enter the value, in this case 10, in a column PrctMakDwn and have it calculate the Showprice and place the marked down value in that column. The percentage will vary for different items, Is that possible?