Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > Access
Back to Access Forum    Comments List
How to round a field which sum Upload Images   Link   Email  
Michelle Seidelin 
Hello Richard.
please look at the photo above as you will see I have been able to divide the minutes giving me the right amount of minutes except minutes come out at  2.45 to get this total I  divide the total minutes by 60 but I don't know how to round the last part where would the round go I've tried a couple of places and not sure do you have any videos on how to round a sum these results show up in a form as you can see not a query or data view will uploao phota as soonit lets me
Michelle Seidelin 

Michelle Seidelin 
Have done more tests and discovered things are not as close as I thought they were when I put in a 30 minute AND it comes out wrong what I have done of course the void maximum minutes divided by 60
So there must be a more accurate way to do this hope someone out there can help
Michelle Seidelin 
I have done some more work on this problem and I have worked out as coming out at a fraction of an hour not minutes as I thought it was if anyone want me to send the query and form to them as I can build the information themselves and a safe database please contact me I can send the query to you is photos as you are able to duplicate the query
Richard Rost 
Don't work with fractions of an hour. Figure out the total minutes per record. Add those up. Now you've got a number like 150 minutes. Integer divide by 60 to get 2 hours. Subtract the difference to get 30 minutes remaining.
Richard Rost 
Access Expert 8 (which you have) has an employee work log very similar to this.
Michelle Seidelin 
sending u a email
Richard Rost 
Please don't. My inbox is overflowing. As I've explained numerous times... if you need tech support, you can post here in the Forums or use my Tech Support page. I don't have time to answer a million questions when I have already covered this stuff in my videos.
Adam Schwanz 
I would make an unbound field called TotalMinutes on your form, and put this in it assuming your SUM fields are called HoursWorked and MinutesWorked.

=(HoursWorked*60)+MinutesWorked

Thatll give you the total minutes.
Then I'd make another unbound field and put this in it

=[TotalMinutes]\60 & Format([TotalMinutes] Mod 60,"\:00")

On your screenshot, this would return 72:27 (72 hours and 27minutes total)

If you just want to round your own sum field, just use the round function, do something like =Round(Sum([MinutesWorked]/60),1) to round to 1 decimal or 0 to round to 0.

Alternatively you can just do \60 instead of /60 to round to integer.
Richard Rost 
Here you go: Timesheets
Michelle Seidelin 
Thanks

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 9:52:36 AM. PLT: 0s