PC Review


Reply
Thread Tools Rate Thread

How do I calculate the # of business days between two dates?

 
 
Judy
Guest
Posts: n/a
 
      15th Apr 2010
I know absolutely nothing about coding. Trying to use calculations in a
report or query to accomplish this. Everything else I have found seems to
include "coding" that goes way beyond my capabilities. Anything a novice can
use?
 
Reply With Quote
 
 
 
 
Mark Andrews
Guest
Posts: n/a
 
      16th Apr 2010
You need to use code:
http://support.microsoft.com/kb/97757

You can call this function in a query
1. make the function a Public Function

In the query have a column like this
WorkDaysCalc: Work_Days([StartDate],[EndDate])

where [StartDate] and [EndDate] are actual fields in your query.

Everyone starts out a "Novice" but the more you do the more experienced you
get.
Otherwise just hire someone to build your database and be happy staying a
"Novice".
I think those are your two options. Almost all Access databases should have
code in my opinion.

HTH,

Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Judy" <(E-Mail Removed)> wrote in message
news:164466A0-76CF-498D-80F8-(E-Mail Removed)...
> I know absolutely nothing about coding. Trying to use calculations in a
> report or query to accomplish this. Everything else I have found seems to
> include "coding" that goes way beyond my capabilities. Anything a novice
> can
> use?


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate business days between 2 dates Vic Microsoft Excel Misc 4 21st May 2009 03:42 PM
Calculate business days between 2 dates Vic Microsoft Excel Misc 0 21st May 2009 03:28 PM
How can I calculate the number of business days between two dates Anonymous Microsoft Excel New Users 3 18th Jun 2008 03:30 PM
calculate number of business days between the 2 dates =?Utf-8?B?TWlyIEtoYW4=?= Microsoft Excel Programming 2 9th Nov 2005 03:20 AM
Is there a way to calculate business working days between dates i. =?Utf-8?B?aGp5b3VuZ2lp?= Microsoft Excel Worksheet Functions 2 23rd Feb 2005 04:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:14 AM.