UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Add Working Days To A Query, Any Version    
 
   
jfearn
post Oct 16 2019, 09:29 AM
Post#1



Posts: 1
Joined: 16-October 19



Hi

Im hoping someone out there can help me to add a number of working days to an existing date. Excluding weekends. Eg, add 3 working days to a date. In my current query, I have =[Date]+5, but of course this does not exclude working days. Is there something I can put into this query to exclude these?

Ive looked at other responses and all have the answer of creating VBA to resolve this. Im afraid I dont know any VBA at all, just know how to create queries.
If this is the only solution, how do I do this; how do I put this into my query? What do I type; how do I link this into my query

I have MS Access on Office 365

Any help appreciated

Thanks in advance!

Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    14th December 2019 - 04:57 AM