<div>
You should use queries to calculate and display data like this, rater than storing calculated data in your table.<br />
<br />
SELECT *, &nbsp; iif(NZ(NumerAttendees,0) = 0 , 0 ,100 * PresenterRating1/NumberAtt<wbr />endees) as PresenterRating1_perc<br />
From tbl2007_conference<br />
<br />
The iif should prevent divide-by-zero errors if NumberAttendees is 0.
</div>


You should use queries to calculate and display data like this, rater than storing calculated data in your table.

SELECT *,   iif(NZ(NumerAttendees,0) = 0 , 0 ,100 * PresenterRating1/NumberAttendees) as PresenterRating1_perc
From tbl2007_conference

The iif should prevent divide-by-zero errors if NumberAttendees is 0.

<div>
Perfect, thanks rockiroads!
</div>


<div>
no probs<br />
do think about not storing calculated values though, it may sound easy now but its more hassle than its worth
</div>


no probs
do think about not storing calculated values though, it may sound easy now but its more hassle than its worth

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a table &quot;tbl2007_conference&quot; with three fields, &quot;NumberAttendees&quot;, &quot;PresenterRating1&quot; and &quot;PresenterRating1_perc&quot;<br />
<br />
I'd like the percentage (PresenterRating1/NumberAt<wbr />tendees x 100) to be automatically calculated in the &quot;PresenterRating1_perc&quot; field. Any help would be greatly appreciated.<br />
<br />
Thanks!
</div>
</div>


Hello,

I have a table "tbl2007_conference" with three fields, "NumberAttendees", "PresenterRating1" and "PresenterRating1_perc"

I'd like the percentage (PresenterRating1/NumberAttendees x 100) to be automatically calculated in the "PresenterRating1_perc" field. Any help would be greatly appreciated.

Thanks!

Calculate percentage

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.