PC Review


Reply
Thread Tools Rate Thread

How can I use NETWORKDAY in Access 2003?

 
 
=?Utf-8?B?SmVmZg==?=
Guest
Posts: n/a
 
      11th Feb 2006
I am trying to find a way to use a fuction like Excels NETWORKDAY in an
Access 2003 table or form. DateDiff won't work for my application.

Any ideas?

Jeff
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      12th Feb 2006
While it is possible to use Excel functions from Access, it introduces a lot
of overhead that, at least in this case, isn't required.

Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/ : there are a couple of different solutions
there.

Alternatively, take a look at my September, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
accompanying sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff" <(E-Mail Removed)> wrote in message
news:620E3877-7371-4556-9497-(E-Mail Removed)...
>I am trying to find a way to use a fuction like Excels NETWORKDAY in an
> Access 2003 table or form. DateDiff won't work for my application.
>
> Any ideas?
>
> Jeff



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAY + Excel 2007 + Excel 2003 Joe Microsoft Excel Worksheet Functions 1 26th Aug 2008 04:42 AM
can you use the NETWORKDAY function in Access =?Utf-8?B?V2FmZmxlcg==?= Microsoft Access 1 1st Aug 2005 09:21 PM
Networkday function for access cynthia3t@aol.com Microsoft Access Getting Started 1 11th Mar 2005 12:14 PM
Simulate MS Excel Workday & NetWorkday functions in MS Access Stephen T. Bate Microsoft Access VBA Modules 0 11th Mar 2004 11:11 AM
Networkday function in MS Access JRW Microsoft Access Queries 1 19th Jan 2004 12:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:46 PM.