Question Locked
How to create a QBE that calculates Extended price minus Discounts.
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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