Report Sum Problem

C

cooh23

Registered User.
Local time
Yesterday, 16:01
Joined
Dec 5, 2007
Messages
169
Hello All,

I am having a difficulty trying to figure out how to sum a group. What I am trying to accomplish is to run a report daily that should calculate each functions and what percentage of the whole day the individual spent on a particular function.

i.e. (just to give an idea - typically, this would be an 8hour day)

Activity Date 3/13/2008
Function: Login
Quantity: 1
Total Time in Minutes: 60
% of Time Spent : 50%

Activity Date 3/13/2008
Function: Check Apply
Quantity: 2
Total Time in Minutes: 60
% of Time Spent on each item : 25%

End of Day total: 100%

Also, I would like to combine alike transactions into one. For example, Report1 shows Check Apply twice on 3/13 with 4 total transactions. I would like to combine this and combine the minutes then total everything everyday.

I am running out of ideas on how to accomplish this report. please see attached report.

Thank you,
 

Attachments

cooh23 said:
i.e. (just to give an idea - typically, this would be an 8hour day)

Activity Date 3/13/2008
Function: Login
Quantity: 1
Total Time in Minutes: 60
% of Time Spent : 50%

Activity Date 3/13/2008
Function: Check Apply
Quantity: 2
Total Time in Minutes: 60
% of Time Spent on each item : 25%

End of Day total: 100%
Click to expand...
Why can't you just add a textbox to the details area of the report with this as its CS...??
Code: 
=[TotalTime]/480
Set the format to percentage. Do the same thing for the End of day total. Does that work I wonder?
 
ajetrumpet said:
Why can't you just add a textbox to the details area of the report with this as its CS...??
Code: 
=[TotalTime]/480
Set the format to percentage. Do the same thing for the End of day total. Does that work I wonder?
Click to expand...

Hi Adam,

That doesn't seem to work. It was just giving me a static answer all across the report. I tried placing it in the footer, header, detail, and it all came up with the answer of 12.50%

I am not sure if what I want is possible. I want the report to look just like the spreadsheet that it is currently in.

Here's what the project is about.
- The database is supposed to keep track of each associates daily activities.
- The DB has different types of functions ranging from logging into the system to going into breaks and lunches. This may seem like micromanagement but it really isn't.
- This is used to keep track of the department to see if we are over staffed or under staffed. This also shows where the individual spends most of his/her time on.
- Throughout the day, everything should equal to 100%.
- For example, on an 8 hour day. Lunch, break, etc.. should show a percentage of the total days work.

I have all of these in a spreadsheet and would like to move everything in access. Is this possible?

Thank you all for your help.
 
Check out the attached revision of your db. I added a field (which I left visible, but you can make it invisible - or you can just make the calculation based on the minutes) and then added the calculation for percent of time.
 

Attachments

Actually, you could just set the controlsource of Text19 to:

=([txtTotalTime])/([Text15]*60)

Without the hidden field.
 
boblarson said:
Check out the attached revision of your db. I added a field (which I left visible, but you can make it invisible - or you can just make the calculation based on the minutes) and then added the calculation for percent of time.
Click to expand...

Bob,

Thank you for the revision. That is exactly what I wanted.

Here's the other part of my problem.

Would it be possible to join all similar items together and add up their quantity and percentages?

For example,
The report you edited shows 2 items for Check Apply on 3/13 and a total quantity of 4.

Would it be possible for the report to show only the following:

Code: 
Functions:                        Quantity           Total Time         % time for day
Check Apply                           4                     120                      100%

Thank you again for looking. I tried this in the report called qryDailyActivitiesAll1 with no luck.
 
cooh23 said:
Bob,

Thank you for the revision. That is exactly what I wanted.

Here's the other part of my problem.

Would it be possible to join all similar items together and add up their quantity and percentages?

For example,
The report you edited shows 2 items for Check Apply on 3/13 and a total quantity of 4.

Would it be possible for the report to show only the following:

Code: 
Functions:                        Quantity           Total Time         % time for day
Check Apply                           4                     120                      100%

Thank you again for looking. I tried this in the report called qryDailyActivitiesAll1 with no luck.
Click to expand...

Is this possible?

Thanks.
 
Thank you all for your help. I was able to figure out the problem.

THank you.
 
Good - I'd been meaning to look at it when I got home and had more time to actually look at it. But, I got distracted again by a huge number of registrations of spammers so I had to go get rid of them before they could spam the forums. :)
 
boblarson said:
Good - I'd been meaning to look at it when I got home and had more time to actually look at it. But, I got distracted again by a huge number of registrations of spammers so I had to go get rid of them before they could spam the forums. :)
Click to expand...

Thank you! You and other members have been a great help. Thank you.
 
You must log in or register to reply here.

Similar threads

D
Solved Summing in reports
Replies
9
Views
284
donkey9972
D
O
Solved How to add fields with the Short Time format?
2
Replies
24
Views
731
Ole
O
J
Solved Report total count in header and grand total. Avg percent calculation. Grand total employee group count.
Replies
11
Views
483
Jomat
J
T
Creating stock balance by month
Replies
5
Views
438
mike60smart
mike60smart
A
If statement in Continuous sub form
Replies
1
Views
249
arnelgp
arnelgp

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom