Query IIf Statement - Best Way?

[Pabs]

Hi there, I'm new to not only this forum but all forums!
I need some help and advice on the best way to do a calculation please.

I'm creating a "master" query that will support a number of Forms and Reports.
I need the query to calculate a value based on a maximum limit as follows:

Part 1
IF [TotalMiles] < 10,001
THEN ([TotalMiles] * £0.45)



Part 2
IF [TotalMiles]>=10,001
THEN I need a value calculated up to an including the 10,000 miles point (at £0.45)

I can do Part 1 but its Part 2 I really struggling with (its probably very easy but my brain has gone into melt down!)

I hope the above makes sense.
Many thanks in anticipation.

Pabs

[pbaldy]

Are you saying that the miles above 10000 are at a different rate? Or? Perhaps some sample values and the expected result would help.

[Pabs]

Hi Paul
Yes there are 2 different rates.
First 10,000 calculated at £0.45, 10,001 and above at £0.25.
I've got to show separately the 10,001 and above.
So for example total of 11,000 would be 10,000 * £0.45 = £4,500, 1,000 * £0.25 = £250.
Cheers
Pabs

[pbaldy]

So for part 2 it's the amount less 10000 *.25 plus 4500.

[Pabs]

Paul
Thanks for this.
I don't think I have explained my issue too well.
I've already catered in another field monies for 10,001 and above miles at £0.25 rate.
I'm just trying to ascertain the "iif statement" for just returning the maximum value of £4,500 in the "£0.45 field".
I need to have two fields to show the both values.
Regards
Pabs

[pbaldy]

Iif(Field>10000,4500, Field * .45)

[Pabs]

Paul
Many thanks
I knew it was simple but total brain failure on my part!
Regards
Pabs

[pbaldy]

No problem, and welcome to the site by the way!