Home Forum Contact

 Access World Forums How to Show Results of Cost * Discount % Then Deduct The Discount In Same Text Box?
 Register FAQ Members List Social Groups Top Posters Search Today's Posts

 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 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?
 04-29-2011, 05:31 PM #2 pbaldy Wino Moderator     Join Date: Aug 2003 Location: Nevada, USA Posts: 32,362 Thanks: 10 Thanked 3,926 Times in 3,867 Posts 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.
 The Following User Says Thank You to pbaldy For This Useful Post: MBM (04-29-2011)
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
Re: How to Show Results of Cost * Discount % Then Deduct The Discount In Same Text Bo

Quote:
 Originally Posted by pbaldy Does this work? =Sum([Quantity]*[Cost]) * .93
Yes! Thank you very much!

 04-29-2011, 05:35 PM #4 pbaldy Wino Moderator     Join Date: Aug 2003 Location: Nevada, USA Posts: 32,362 Thanks: 10 Thanked 3,926 Times in 3,867 Posts 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.

 Thread Tools Display Modes Rate This Thread Linear Mode Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World     Access World News     Site Suggestions     Introduce Yourself     The Watercooler Microsoft Access Discussion     General     Tables     Queries     Forms     Reports     Macros     Modules & VBA     Theory and practice of database design     Access Web Microsoft Access Reference     Access FAQs     Code Repository     Sample Databases     Microsoft Access Tutorials     Microsoft Access User Groups Apps and Windows     SQL Server     Crystal Reports     Visual Basic     VB.NET     Word     Excel     Web Design and Development         ASP and ASP.NET         PHP & MySQL     Windows     Other Software     Hardware Questions and Answers Non-Access Issues     Politics & Current Events     Debates     Gaming     Sports, Health & Fitness     Gadgets     Small Business

 Similar Threads Thread Thread Starter Forum Replies Last Post Shooting Star Forms 1 02-12-2009 06:37 AM nexus2011 Tables 8 03-22-2007 04:52 AM Neo General 3 05-13-2003 07:09 AM 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 08:22 PM.

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