percent

[mavergara]

im so frustrated, why im getting an error with my percent control source, pls help me. prior to this error, the percent works perfectly until i copy paste the code to another field and all my percent field turned to error. heres my code:
=IIf([total171]=0,0,[6171]/[total171])

also, why im getting a black background in one of my fields. i also attached my work for your reference. any help would be much appreciated. thanks

 

[Trevor G]

Which version of MS Office are you using. I had a quick look at your database, but I think you are using 2010 and trying the percentage formula in the table, is that right?

 

[mavergara]

i overlook my table, its like this, my tblreport holds all the number of responses per each response from my tbl surveyquestions, apparently, i have 7 responses in my tblsurvey questions but my tblreport still unupdated and the responses still 5. Do i missed something? pls advise. thanks!