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
NetWorkDays Function Upload Images   Link   Email  
Juan C Rivera 
Good Morning All,
Richard this looks like something I can use can you do a tech help video showing different ways to use this?

I do construction and I always ask the question when told this is a 90 day project.  Workdays or total days to complete...

Live long and prosper
Juan
Richard Rost 
I cover it pretty thoroughly in my Advanced DateTime Seminar. However, if you'd like me to put together a short TechHelp video on it, I would be happy to. The function doesn't exist in Access, so I had to write one.
Juan C Rivera 
Yes please I think this function is very useful for Project Managment.  I'm always looking at dates and adding bad weather days to get a start date and end date.  Then I add work hours to get the budget for the project.  This will be a most useful function in my line of work. No rush I know you have plenty on your plate to do
Thanks you Richard.  
V/r
Juan
Juan C Rivera 
Good Day ALL...
I got it to work about 98% of the time.  Here is what I did made a form and two fileds Startdate, EndDate.  
Dim daysworked As Long
Dim D1 As Date, D2 As Date
If StartDate  "" Then
D1 = Forms!projectlisting![StartDate]
D2 = Forms!projectlisting![EndDate]
Else
Exit Sub
End If

daysworked = myNetWorkDays(D1, D2)


StartDate = ""
EndDate = ""

if I pick a date that starts on Sun and ends on Sat I get 5 net days...  If I pick a Tue and end on Thu I get 2 days.  What did I do wrong?  If I work Tue, Wed and Thu that's 3 days.
Any feedback will be appreciated.

V/r
Juan
Richard Rost 
Yeah, that should work fine. I'll take a look at it when I make the TechHelp video. You're on the list.
Juan C Rivera 
Big Thanks I have done leap and bound with this channel.  Big Thanks for the continued support.

V/r
Juan

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 6:40:28 AM. PLT: 0s