Access IIF Formula Help

[Makyaarts]

I am a MS Access Newbe.

Trying my hand at a Payroll.

Can I please get help with an IIF Formula on a Payslip Form.

FieldName is UIF.

We have a Monthly Limit for Calculation UIF. Our UIF percentage is 1% but the Limit is 14800.00. Which means All GrossSalaries calculate 1% but as soon as the Salary is higher than 14800.00 only 148.00 will be charged.



Current Formula is: UIF=IIf([UIFReg]=True,[GrossWage]*0.01,0) Works correctly.

But the part of Grosswage >= 14800.00 must only be 148.00 I am not sure how to add.

Will appreciate all info.

[June7]

So you need to calculate the SUM of each employee's wages for the month and if that SUM >= 14800, don't calculate UIF and/or calculate so doesn't exceed 148 for the month.

[Makyaarts]

So you need to calculate the SUM of each employee's wages for the month and if that SUM >= 14800, don't calculate UIF and/or calculate so doesn't exceed 148 for the month.

Think should write a custom VBA function to handle this.

If have all the Salary Sums in place just need to get the UIF Calculated if the Salary is more than 14800.00. And yes for the rest you are correct.

[June7]

Don't know your db structure nor buisness process so really can't advise more specific.

[accesstos]

Why not
IIf([UIFReg] = True, IIf([GrossWage] < 148000, [GrossWage] * 0.01, 148), 0)

[June7]

I was assuming GrossWage was just for the current payperiod, not the entire month. Are payperiods weekly, biweekly, semi-monthly, monthly? If paid every 2 weeks, how should 'monthly' amount be determined?

[Makyaarts]

I have Weekly, Bi-weekly and Monthly Pay Periods, but the Monthly Period is the only period where Salaries go over 14800.

[Makyaarts]

Works like a charm. Thank You

[accesstos]

You are welcome!

Happy to help!