Solved

Calculating Percentage on Report

Posted on 2011-02-11
1
267 Views
Last Modified: 2012-05-11
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

0
Comment
Question by:gcgcit
1 Comment
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 34873634
try

=format((txtHolidayHoursPayAvailable - txtHolidaysHoliday)/ txtHolidaysHoliday,"percent")
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now