Query Calculation Help

[all7holly]

I need a query to calculate the following.

CABIDayNormalRate: IIf([CABIDayHours]<=8,[ CABIDayHours]*62.5)
CABIDayOTRate: IIf([CABIDayHours]>=8,[hours]*93.75)

When I run the query. It’s only calculating if there is less that 8 hours. I need it to be able to take those 8 hours or less and multiple them by 62.50, and take anything over those 8 hours (example 2 extra hours) and multiply them by 93.75.

Thanks for the help.

Holly

 

[plog]

TotalRate: IIf([CABIDayHours]>8, (500 + ([CABIDayHours]-8)*93.75), [CABIDayHours]*62.5)

 

[all7holly]

Perfect thank you! I have one more question. I need to calculate 2 more categories. Below is the expression I have. But they are not calculating properly.

TotalProjectManagerRate: IIf([ProjectManagerHours]>8,(500+([ProjectManagerHours]-8)*95),[ProjectManagerHours]*72)

TotalAMSRate: IIf([AMSHours]>8,(500+([AMSHours]-8)*95),[AMSHours]*72)

 

[plog]

I'm sure they are calculating correctly, it's just not what you expect. To get them to what you expect them to return I would need an explanation and some sample data of what you are putting in, what you are getting out and what you expect.

 

[all7holly]

I need a query to calculate the following.

TotalProjectManagerRate: IIf([ProjectManagerHours]>8,(500+([ProjectManagerHours]-8)*95),[ProjectManagerHours]*72)

I need it to be able to take those 8 hours or less and multiple them by 72.00, and take anything over those 8 hours (example 2 extra hours) and multiply them by 95.00.
For Example an employee worked 9 hours as a ProjectManager. 8 hours straight time and 1 hour overtime. This should equal $671, however the database is calculating a total of $595. And ideas?

 

[plog]

You need to replace the 500 with 576. That value is determined by the rate (in this instance $72\hour) multipled by 8 hours.

 

[all7holly]

Perfect Thank you so much!!!