<div>
<div class="content wysiwyg-content">
What is the quickest way to calculate the percentage difference between two fields on a report?<br />
<br />
txtHolidaysHoliday = 80<br />
<br />
txtHolidayHoursPayAvailabl<wbr />e = 87.30<br />
<br />
The record has 7.30 hours extra holiday pay available over what they can take, but how to I find out the percentage over excess holiday hours and put it in the control source of txtPercentageExcessHoliday<wbr />s<br />
<br />

</div>
</div>


What is the quickest way to calculate the percentage difference between two fields on a report?

txtHolidaysHoliday = 80

txtHolidayHoursPayAvailable = 87.30

The record has 7.30 hours extra holiday pay available over what they can take, but how to I find out the percentage over excess holiday hours and put it in the control source of txtPercentageExcessHolidays



Calculating Percentage on Report

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.