How to querie Date difference minus weekends

[lactbc]

Hi,

I have a Access database with 2 date fields, Date Sent and Date received. How would I go about querying the difference between Date Sent and Date Received without counting Weekends because business is closed during weekends? e.g difference between 1/3/03 and 1/13/03 is 7 days.

Also suppose I have 100 records, How would I calculate the average time difference from those 100 records? Thank you very much for any help anyone can offer.

 

[BobJacksonNCI]

It's best to use Advanced Search before posting as many questions have already been answered.

E.G., try searching for "business days".
Post back if you don't find anything useful.

Also, you can look up the "workday" function in Access help.


HTH,
Bob