Calculating workdays in a query

  • Thread starter Thread starter PRobbins
  • Start date Start date
P

PRobbins

Running Windows XP Professional, using Access 2000

I am trying to run a query in Access that calculates the
number of working days between two columns (Date Received
and Date Due) in an existing database file.

In the query I added a column named "response time". In
that column I have the following equation that is
currently calculating the number of days between "Date due
and "date received:, but the equation also calculates Sat.
and Sun.

Equation that is calculating response time is:

Response Time: [RFQ Quotes Due]![Due Date]-[RFQ Quotes
Due]![Date Received]

In addition, I tried to follow the equation (see below)
for Networkdays in the Access help menu, but can't seem to
get it to work correctly. I keep getting a message
saying "undefined function "Networkdays" in expression.

Equation provided in Access help:
NETWORKDAYS(start_date,end_date,holidays)

Equation I tried to input.
Networkdays([date received,date due])

I am not real good at using equations or query's in Access
(as you can tell), so any help would be greatly
appreciated.

Thanks,
PRobbins
 
Unfortunately, the Help file's simply wrong in this case. NetWorkDays is an
Excel function, not an Access one. That's the problem with trying to use one
Help file for all products...

Take a look at the Date/Time section of "The Access Web"
http://www.mvps.org/access There are a couple of different approaches there.
 
Back
Top