Prorata calculation - ARRGGHHH!

[t***@googlemail.com]

I have a query that calculates a how many hours someone has worked in a given place and then pro ratas the wages to that place.

The problem comes is that the straight forward calcuation of [FullCost]*[ProrataHrs] sometimes generates a figure that is more than 100% because of other pay add ons

How do I create a the same calculation [FullCost]*[ProrataHrs] but get it to cap any figure that goes over 100% to 100%?

thanks

craig

[Rob Parker]

Perform the calculation on figures that don't include any "other pay add
ons". From what you've told us, it's impossible to be more specific.

Post by t***@googlemail.com
I have a query that calculates a how many hours someone has worked in a
given place and then pro ratas the wages to that place.
The problem comes is that the straight forward calcuation of
[FullCost]*[ProrataHrs] sometimes generates a figure that is more than
100% because of other pay add ons
How do I create a the same calculation [FullCost]*[ProrataHrs] but get it
to cap any figure that goes over 100% to 100%?
thanks
craig