Percentage Problem in a Query

[cashe]

Hi All,

I need to convert an Excel expression to work in a Access2k query but its not working.

The excel expression in the field "10% Held Back" is:
92%*(6%*(C7-(11.9%*C7)))

Cell C7 relates to the "Amount_Payed" field in the Access DB tblPayment.


Can this expression be changed to work in Access and what would it look like?

Thanks in advance

Cashe

 

[DanChard]

Use the following as the SQL behind a query:

select 0.92*(0.06*(amount_payed-(0.119*amount_payed))) as [10% Held Back]
from tblpayment;

Good luck!

 

[cashe]

Sorry for the late reply but thanks DanChard it worked a treat. I must have had a memory blockage that day