Solved

Calculating Percentage on Report

Posted on 2011-02-11
1
254 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

708 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

18 Experts available now in Live!

Get 1:1 Help Now