TigerNoire
MIS
Hello,
I've built a database to keep track of payroll information and I need to have it automatically deduct a half an hour if the person works more than six hours. The complicating factor is that I only need the deduction if the person is in a certain department and worked a certain project.
Example: John works 7 hours in box office for general hours. (It's possible for John to work in box office for a specific show as well.
I've tried the IIF statement:
IIf([RegHours]>6 And [ProjID]="Pbox",([RegHours]-0.5),[RegHours])
in the Criteria row of a query and it doesn't work. It does work as a column but I only need it to change the hours for people that work a "Pbox" event, not everyone.
Suggestions?
I've built a database to keep track of payroll information and I need to have it automatically deduct a half an hour if the person works more than six hours. The complicating factor is that I only need the deduction if the person is in a certain department and worked a certain project.
Example: John works 7 hours in box office for general hours. (It's possible for John to work in box office for a specific show as well.
I've tried the IIF statement:
IIf([RegHours]>6 And [ProjID]="Pbox",([RegHours]-0.5),[RegHours])
in the Criteria row of a query and it doesn't work. It does work as a column but I only need it to change the hours for people that work a "Pbox" event, not everyone.
Suggestions?