=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
=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

Last edited: