How do I calculate the # of business days between two dates?
in [Reports]
|
From: Judy on 15 Apr 2010 16:05 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?
From: Mark Andrews on 16 Apr 2010 09:10 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" <Judy(a)discussions.microsoft.com> wrote in message news:164466A0-76CF-498D-80F8-FEA07A068564(a)microsoft.com... > 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?
|
Pages: 1 Prev: counting records shown in a report Next: Formatting in columns |