Need these excel calculations in my database...HELP

lowanam1

Registered User.
Local time
Yesterday, 23:57
Joined
Jan 13, 2012
Messages
106
=ROUND(Y28*29%,0)
=Y28+Z28
=ROUND(AA28*$AC$5,0)
=AB28+AC28=(AA28*$AF$5)+((AD28*(1+RATES!$B$6))*(1+RATES!$B$8))+((AE28*(1+RATES!$B$6))*(1+RATES!$B$8))
=ROUND(Y41*29%,0)=Y41+Z416514
=ROUND(AA41*$AC$5,0)
=AB41+AC41
=(AA41*$AF$5)+((AD41*(1+RATES!$B$6))*(1+RATES!$B$8))+((AE41*(1+RATES!$B$6))*(1+RATES!$B$8))
=ROUND(Y47*29%,0)=Y47+Z4769570
=ROUND(AA47*$AC$5,0)=AB47+AC47
=(AA47*$AF$5)+((AD47*(1+RATES!$B$6))*(1+RATES!$B$8))+((AE47*(1+RATES!$B$6))*(1+RATES!$B$8))

I need to put the above formulas in a query. here is my query....Microsoft Access 2007

SELECT tbl_BAEComp.[WORK ITEM NUMBER], tbl_BAEComp.[SUB DISCIPLINE], tbl_BAEComp.[BAE LABOR HOURS], tbl_BAEComp.[29 % THE 29% EQUATES TO 6% PMO 6% QA AND 17% SUPERVISION], tbl_BAEComp.[TOTAL HOURS], tbl_BAEComp.[MATERIAL VALUE], tbl_BAEComp.CONSUMABLES, tbl_BAEComp.[TOTAL MATERIAL VALUE], tbl_BAEComp.[SUB QUOTES], tbl_BAEComp.TOTAL
FROM tbl_BAEComp
ORDER BY tbl_BAEComp.[WORK ITEM NUMBER];

Please help. Im stumped. Thanks :confused:
 
Last edited:

Users who are viewing this thread

Back
Top Bottom