Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate Business Days

Status
Not open for further replies.
ptw78

ptw78

Technical User
Mar 5, 2009
155
US
Is it possible to calculate how many business days have passed in an access calculate field, assuming there already is a start date in another field? I'm assuming the weekday function would be used, but not sure.
 
Sort by date Sort by votes
Is this possible to do using the query design using a calculate field? The start date I'm going to be using will be from another field in the same query. Not sure I 100% understand the link you posted.
 
Upvote 0 Downvote
Nevermind, I think I got it all. Thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ptrifile
  • Locked
  • Question
# Business Days
Replies
3
Views
128
MajP
MajP
sameh2006
  • Locked
  • Helpful tip
I want to get a field calculated in
Replies
1
Views
127
SkipVought
S
TJVFree
  • Locked
  • Question
Number of days to go and past days in a month 2
Replies
4
Views
109
dhookom
dhookom
monkeysee
  • Locked
  • Question
Create Calculated Field in Query using multiple fields. 1
Replies
3
Views
144
monkeysee
monkeysee
leeamra
  • Locked
  • Question
I want to identify the data in an interval of time between two days
Replies
2
Views
97
leeamra
leeamra

Part and Inventory Search

Sponsor

Back
Top