Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-29-2011, 02:22 PM   #1
MBM
Newly Registered User
 
Join Date: Sep 2010
Posts: 31
Thanks: 6
Thanked 1 Time in 1 Post
MBM is on a distinguished road
Question How to Show Results of Cost * Discount % Then Deduct The Discount In Same Text Box?

txttotal (text box that outputs sum of two fields)
=Sum([Quantity]*[Cost])

txtdiscount (multiplies sum of two fields * 7%)
=[txttotal]*0.07

How do I show the sum of the two fields with the 7% discount in the txtdiscount text box?

MBM is offline   Reply With Quote
Old 04-29-2011, 05:31 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,929
Thanks: 9
Thanked 3,844 Times in 3,787 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: How to Show Results of Cost * Discount % Then Deduct The Discount In Same Text Bo

Does this work?

=Sum([Quantity]*[Cost]) * .93
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
MBM (04-29-2011)
Old 04-29-2011, 05:34 PM   #3
MBM
Newly Registered User
 
Join Date: Sep 2010
Posts: 31
Thanks: 6
Thanked 1 Time in 1 Post
MBM is on a distinguished road
Re: How to Show Results of Cost * Discount % Then Deduct The Discount In Same Text Bo

Quote:
Originally Posted by pbaldy View Post
Does this work?

=Sum([Quantity]*[Cost]) * .93
Yes! Thank you very much!

MBM is offline   Reply With Quote
Old 04-29-2011, 05:35 PM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,929
Thanks: 9
Thanked 3,844 Times in 3,787 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: How to Show Results of Cost * Discount % Then Deduct The Discount In Same Text Bo

Happy to help!

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do a discount Shooting Star Forms 1 02-12-2009 06:37 AM
Customer Discount To Product Discount Group nexus2011 Tables 8 03-22-2007 04:52 AM
Add discount Neo General 3 05-13-2003 07:09 AM
discount kwalker Forms 1 08-11-2002 02:43 AM
[SOLVED] Discount problems kwalker Tables 4 08-11-2002 02:36 AM




All times are GMT -8. The time now is 10:32 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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