did my question post about Percent in an ACCESS report?

R

Robert

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
 
A

Al Campagna

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top