Calculation in Access 2003 Query

Hi experts,

Our clients have their individual budget, and they are allowed to use over $100 or 10% on top of the [budget] which is lesser. I'd like to have a field in query, that calculates the [Budget]+$100 or [Budget]*1.1 and takes which is the less. How do I do it?

Thank you!
howruaz9Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
BudGetLimit:  IIF([Budget]+100<[Budget]*1.1,[Budget]+100, [Budget]*1.1 )

Jim.
0
 
howruaz9Author Commented:
Yes, Jim, it's perfect. Thank you very much!
0
All Courses

From novice to tech pro — start learning today.