Access 2000 - Query Calculation help

The more I understand, the less I know!

Here it is as simply put as I can state it:
> I collect hours worked per person for a labor report
> We assign a dollar amount for each person per month
i.e. Person A is assigned $15,000 per month (this is for accounting/allocation purposes only)

> Therefore, Person A can never equate to more than $15,000 per month, no matter how many hours they work in a month.

> The hours a person works is placed into two different categories: X1 and X2, and each category is assigned a dollar amount as stated above. Let's say X1 = $10,000 and X2 = $5,000 (basically X1 dollars = 66% and X2 dollars = 34%)

> My table tracks, per week, the total hours worked in both X1 and X2.

> My query takes these hours, figures the percentage of time worked, and applies the dollar amount based on the X1 and X2 idea above:

EXAMPLE: Person A works 40 hours (100% of the week)
Therefore X1 = $10,000 and X2 = $5,000 for the week

EXAMPLE: Person B works 30 hours (75% of the week)
Therefore X1 = $7,500 ($10k x 75%) and X2 = $3,750 ($5k x 75%)

EXAMPLE: Person C works 50 hours (125% of the week)
Therefore X1 = $10,000 and X2 = $5,000 for the week

What I need:
I need to apply criteria to my query that says no matter how many hours beyond 40 a person works, the maximum dollar amount shown will always be $10,000 and $5,000.

I am not sure how to do this at all. Any help, any explanations, any direction would be greatly appreciated!

Thanks!
Ana

 

Hello
This was posted a long time ago but...
To do this you will need to use VBA (Visual Basic for Applications) coding.