Web Development



How to create a QBE that calculates Extended price minus Discounts.

By pilgrim001 ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums