Search results

Jzwp22, As far as i can tell, that function is working beautifully! I am still going through it to understand the logic a bit better, and ill continue spot checking the function. Really appreciate you helping me here, this community has been great to me already!

Mr. B thanks a lot for looking at this for me. In order to get your function to work in a query i had to change the holiday table name, and holiday field name to match mine. Otherwise i ran it as is. In a query of 11/17/2011 12:36:03 AM 11/29/2011 3:36:55 PM the function returned 4140 where...

Thanks for taking a shot at it jzwp22! Looks to be on the right track. However, when i pulled the function into my database i noticed a problem immediately. On dates opened and closed on the same day( negative values are returning. For example, try StartDate "5/18/2012 12:00:56 AM" and...

The more i look into this, the more work i realize is behind what i want to accomplish. Thanks so much for your time. As for your questions: 1. Yes, tickets can and do start on a weekend or a holiday. 2. Yes, tickets can and do occur outside 8-5. 3. Yes, tickets are often closed on the same...

Awesome, thanks for the reply. I'll continue hacking away at it myself for now, but i look forward to your feedback! I seem to be making some headway by changing some dim as integer to "dim as variant" (in order to keep the TimeValue of the Dates) and changing the return interval to "n"...

Hey guys, This is my first post on access-programmers, so be gentle please! My issue is this: I am trying to calculate the number of minutes between the opening of a ticket and its close using Access 2010. Obviously this is simple with DateDiff, but i also need to exclude holidays, weekends...