October 13, 2004 at 3:47 pm
I'm currently working on a Payroll report that pays bonus for working 100% of the hours scheduled.
If the Actual hours is 100% of the Scheduled hours pay .25 bonus per hour.
Looking for help if possible.
Mark
October 13, 2004 at 5:19 pm
Need to know the tables involved DDL and how the data is represented such as hours worked and hours scheduled. Then we can help better.
October 14, 2004 at 1:26 pm
I found that this statement will work, but the problem is I need it greater than...
=(IIf([SUBPer]<'100',([HRSWKD]*0.25)))
If I put > no data shows and if I put >= no data shows.
[SUBPer] is the percent field that has the percentage worked.
Not sure if this is enough info...Let me know.
Mark
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply