Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 04-17-2018, 05:06 AM   #1
Newly Registered User
Join Date: Apr 2018
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
mantas123 is on a distinguished road
Post making a discount query based on repeated orders

Hello community, I am trying to make a calculated field that would give me a discount on repeated orders based on multiple I already have done a discount on large orders
here is the statements in my calculated fields:
Order Cost: [Quantity]*[Product Cost]+[fixed Delivery Cost]
Discount: IIf(([Order Cost])>100,([Order Cost])*0.1,0)
Total cost: [Order Cost]-[Discount]

Thanks in advance
Attached Images
File Type: png query.png (54.4 KB, 15 views)
File Type: png query 2.png (8.5 KB, 16 views)

mantas123 is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP! Trying to make a query where every 5 orders a customer receives a discount. joe_madeira Queries 7 12-08-2011 11:49 PM
How to Show Results of Cost * Discount % Then Deduct The Discount In Same Text Box? MBM Forms 3 04-29-2011 05:35 PM
Making a form based on a query with a subform? NewShoes Queries 4 08-17-2009 09:19 AM
Customer Discount To Product Discount Group nexus2011 Tables 8 03-22-2007 04:52 AM
Making the Orders Form into a Web Page pmcleod Forms 2 06-10-2005 08:42 AM

All times are GMT -8. The time now is 09:26 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World