Access 2007 Form Calculation

Microsoft Office access 2007 - upgrade
August 4, 2010 at 06:16:10
Specs: Windows XP
I need a calculation that calculates a 5% tax on the amount. Ok, that's easy enough - Equipment*.05.

My issue is that the amount does not get taxed on anything over $5,000. How do I tell it to tax only the first $5,000?


See More: Access 2007 Form Calculation

Report •


#1
August 4, 2010 at 08:44:31
IIF([equipment]>=5000,5000 * .05,[equipment] * .05) as Tax

Report •
Related Solutions


Ask Question