I’ve create a Purchase Order Database for my employer. This is my first effort. I’ve managed to create a query that calculates ‘UnitPrice’ by ‘Quantity’ and have named that expression as “ExtendedPrice”. What I now need to do is create a calculation that subtracts the Discounts[percentages] from the ExtendedPrice.
Could anyone advise me on how to do this.
Thank you very Much
Andrew
