did my question post about Percent in an ACCESS report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have 4000 base hours with zero overtime.
I have a report showing [extrahrs] by date.
In the report foot I show a textbox called SumExtrahrs which is
=sum[Extrahrs].
I have a textbox called Percent.
I want it to show the percent of Sum[ExtraHrs]+4000 divided IN TO 4000.
example: sum extra hours = 4067.25
divided in to 4000 equals 0.983465
This is 1.65%. That is the answer i want to see in the textbox titled
Percent.

Any ideas?
Thanks,
Robert
 
Robert,
First, don't name your field calculated Percent. It's a 'reserved' word in Access, and
should not be used. Name it something like PctExtraHours.

If your total for all hours is 4067.25 and you want to know what percentage 67.25
represents of that amount,
67.25 / 4067.25 = .0165345 (formatted as Percent = 1.65%)
or...
(67.25 / 4067.25) * 100 = 1.65 (as #.00 formatting = 1.65)

In your post, your calculation determines what precentage 4000 represents of 4076.25.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top