By Richard Rost 19 months ago
Add a Discount Percentage Rate to Orders
In this Microsoft Access tutorial, I'm going to show you how to add a discount percentage rate to your order entry database and invoice.
Jerry from Tacoma, Washington (a Gold Member) asks: I've been using your Invoicing template for a while now. Thank you for making that available. How can I add a discount percent to the order, so if I'm having a 25% off sale it's easy to calculate?
Members will learn how to set up automatic tiered discount rates based on the customer's total past sales. So if they've bought $10,000 worth of material, they get a 5% discount on future orders. If $20,000 then 7% and so on. We'll learn how to use the BeforeInsert event.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, tiered discount rates, Discount calculation in ms access, How do you calculate a discount, Creating a discount, Calculate Discount Amount, Calculating percent discount, how to do discount on access, Access calculating discount rate, calculating sales tax
Subscribe to Order Discount
Get notifications when this page is updated