i am trying to enter a calculated field in design view for price and if its more than 20.00 a .04 sale price and if its less than 20.00 .02 for a new field that says sale prce
Novice
Windows 7 64bit 
Access 2010 32bit
i am trying to enter a calculated field in design view for price and if its more than 20.00 a .04 sale price and if its less than 20.00 .02 for a new field that says sale prce
VIP
Windows 7 64bit Access 2010 32bit
Don't understand. What are the .04 and .02 and what is the formula you want to use them in?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 64bit Access 2010 32bit
when the price is >20, 4%discount and <20 2% discount
VIP
Windows 7 64bit Access 2010 32bit
Try:
[Price] * IIf([Price]<=20, .02, .04)
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How to calculate percentage of one field's value to another?
Calculate one field based on another one
Use report to Calculate sum and percentage
Posting Permissions
Reply With Quote