Search results

Can you let me know what is wrong with my formula.... I get the answer of $0. Thank you Nz([Total Hours],0)*Nz([tbl_BAEComp]![Rate],0)+Nz([MATERIAL VALUE],0)*Nz([tbl_BAEComp]![G&A Rate],0)*Nz([tbl_BAEComp]![Award/Inc Fee],0)+Nz([SUB QUOTES],0)*Nz([tbl_BAEComp]![G&A...

I also entered the expression with the Nz function this way and got the result of 0 which is not the total dollar value of the expression. Total: Nz([Total Hours],0)*Nz([tbl_BAEComp]![Rate],0)+Nz([MATERIAL VALUE],0)*Nz([tbl_BAEComp]![G&A Rate],0)*Nz([tbl_BAEComp]![Award/Inc Fee],0)+Nz([SUB...

Ok I looked up the Nz function and learned that I needed to wrap my formulas with the Nz function because there are fields that are null. Now the expression looks like this and totals to 0. Which is not the total dollar value of the expression. did I wrap the Nz function wrong?? 0 is not the...

ok thanks by did not work I mean: The formula did not calculate the total. I expected to see a dollar value and the field is blank.

I changed/added the tables/expressions to read like this instead and it still did not work : Yes the fields are referenced correctly. Am i missing comas?? Total: [Total Hours]*[tbl_BAEComp]![Rate]+[MATERIAL VALUE]*[tbl_BAEComp]![G&A Rate]*[tbl_BAEComp]![Award/Inc Fee]+[SUB...

I can't get this calculation to total. Please let me know if I have it entered incorrectly. Thank You! Total: Round(([Total Hours]*48.55)+([TOTAL MATERIAL VALUE]*6.4)*(11.23+[SUB QUOTES])*(6.4*11.23),0)

Hi, Im Lowana I live in beautiful San Diego. I just created my first database and love ACCESS :)

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