Is there a way to set up a query to count business days instead of calendar days?
R Randal Jan 21, 2004 #1 Is there a way to set up a query to count business days instead of calendar days?
M Michel Walsh Jan 21, 2004 #2 Hi, You can use a VBA function that does that, inside a query, if you are using Access itself (by opposition to VB, C++, etc) with Jet. There is a whole bunch of related functions at http://www.mvps.org/access/datetime/date0012.htm Hoping it may help, Vanderghast, Access MVP
Hi, You can use a VBA function that does that, inside a query, if you are using Access itself (by opposition to VB, C++, etc) with Jet. There is a whole bunch of related functions at http://www.mvps.org/access/datetime/date0012.htm Hoping it may help, Vanderghast, Access MVP
