How do i dicount a field in access like cost?

[School Daddy]

I need to know how to discount a cost field by 15%

 

[Al Campagna]

School Daddy,
= Cost - (Cost * .15)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[fredg]

I need to know how to discount a cost field by 15%

100% - 15% = 75%
Price after discount =[Cost] * .75

 

[Philip Herlihy]

I need to know how to discount a cost field by 15%

100% - 15% = 75%
Price after discount =[Cost] * .75

Oops! for 75, read 85.

Phil

 

[fredg]

I need to know how to discount a cost field by 15%

100% - 15% = 75%
Price after discount =[Cost] * .75

Oops! for 75, read 85.

Phil

Well, I just accounted for inflation.
Thanks for correcting my poor math.

 

[John W. Vinson]

I need to know how to discount a cost field by 15%

Create an Update query based on your table, and update the cost field to the
corrected expression in Philip's response to Fred's.