A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report that generates number of working days within two date range



 
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2005, 03:33 PM
Sam
external usenet poster
 
Posts: n/a
Default Report that generates number of working days within two date range

Hello All

I suppose you may have been asked this question a million times, however I
have a report that counts the number of days from a start date and end date.
I have a query set up and a very basic formulae to count these days I.E.
Date()-[DateOfStatus]. this counts the number of days from today and the date
of status. I would like this query to only count working days (I.E. Monday to
Friday)

I have seen several posts requesting assistance with calculating working
days and someone has replied with a lengthy code to place somewhere, however
I am not sure that this is what I need to do the job.


Can someone steer me in the right direction?
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box (1st) Populating Text Box (2nd) Field AccessRookie Using Forms 1 April 6th, 2005 11:37 PM
Combo Box & Text Box AccessRookie Using Forms 3 April 6th, 2005 11:33 PM
Help!! I'm running around in circles! CathyA New Users 19 December 12th, 2004 07:50 PM
Number of working days between two dates david Worksheet Functions 4 June 15th, 2004 04:14 AM
Number of working days between two dates James Silverton Worksheet Functions 3 October 23rd, 2003 12:40 PM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.