Urgent help on a Query

[Hazel]

I have a field named Admin Charge which is the sub total multiplied by 12.5% (sub total*0.125) now if this is equal to or over £50.00 i want it to equal no more than £ 50.00 going nuts on how to calculate it (Access 2002) someone please help

 

[FoFa]

AdminChrg: IIF([sub total]*0.125)>50.0,50.0,[sub total]*0.125)

 

[Hazel]

Thank a Million

Thank a million was going nuts take care