Discussion Locked
Form calculations
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am new to Access 2007
Having a problem getting the correct Discount Price and having it updated to my table
List Price is $42.99
my discount percentage is 15%, but the discount price is showing $0.15.
when I use the control source, it works fine (but does not save to my table)
=[list price]*[discount]
When I use the event procedure afterupdate
[discount amount]=[list price]*[discount](1-[discount])
I don't get anything
Hope someone can help