Calculating Net Pay for Salary & Hourly Employees

[brbrooks73]

Trying to calculate net pay for salary and hourly employees. I am able to get them to calculate each in their own separate expression but when I combine them and run it I get blanks. Not sure what I am doing wrong. here is the two expression I created.



Taxes: [Payroll Info]![PAY_FEDTX]+[Payroll Info]![PAY_STATETX]+[Payroll Info]![PAY_FICA]+[Payroll Info]![PAY_SAVINGS]

Net_Pay: [Payroll Info]![PAY_MONSALARY]-[Taxes] And ([PAY_HRRATE]*[PAY_HRSWORKED])-[Taxes]

I appreciate any assistance anyone can give me. I have been working on this for the past 3 days.

Thanks,
Brandi

[TheShabz]

You cant run them together as you are referencing Taxes in Net_Pay when Taxes doesn't exist yet. In your first query, run Taxes and also create a blank field. Then run an update query with Net_Pay to update the field you created in the first one.

Not sure if there's another way around it.

[rpeare]

you have two different types of employees and if you have a field that indicates if they are hourly or salaried you can do a formula like this:

iif(EmpType = "H", <hourly calcualation>, iif(emptype = "S", <Salary calcuation>, null))