Recent content by mikeh1992

Thank you!! I'm a little optimistic about opening a DB. Is there code similar to what I'm looking to do that I could paste into SQL and play around with?

That part works fine. I'm calculating the number of business days between a pick up date an a specific allowed number of days for something to be in transit for. So this is correct. The issue lies within being able to have the do until statement register when landing on a holiday. According to...

Hi All, I am using the below code to calculate number of business days excluding Holidays. The code works great unless the date lands on a holiday. For some reason the current code I have does not register the "Do Until" statement correctly when I = holiday date (works fine if the holiday is...

Hello, I am trying to export a query into excel using vba, the problem I am having is it is not consistently working. Sometimes the data will be over written, other times the previous data will be present once ran. Not sure what is causing this? At first I thought it might be a timing issue...

Hi All, I am trying to calculate an end date using a "Start Date" and an expected number of days it would take to ship a product ("Expected Transit Time"). However, I am having trouble doing so. I need to find a way to add this expected number of days to the ship date, but skip over any...

Hello, I am looking to construct a query that will allow me to update a table based off calculated delivery date. I do not want to include weekends since no delivery will occur. Is there a way to do this in Access? I noticed there was not a "Networkdays" function like there is in Excel. Below...