need to count business days between two dates

[nolegirl]

Pretty simple, I just need to count the number of business days between two dates in an Access query and update them to a local table in the database. What expression should be used to calc the # of business days? I tried the DateDiff function but it didn't return what I was looking for.

Thanks.
MR

 

[lespaul]

Check out FAQ181-261

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi