PC Review


Reply
Thread Tools Rate Thread

How can I query a set of dates but exclude non-working days?

 
 
Pilgrim72
Guest
Posts: n/a
 
      3rd Jun 2010
Hi there,
I was hoping that someone might be able to help me. My Access knowledge is
at best, rather limited, and I am stuck now and cannot proceed further
without help!

I am building a database of records for work received on certain dates, and
completed by certain dates. I need to be able to to query which work loads
where received on a given date, and whether or not it has a completed date
within a specified limit (say, 3 days). I intend to have a query that
displays records that do fall within the target, and a query that displays
records that do not.

The trick is that I need it to count only WORKING days, i.e. Monday to
Fridays only. I really dont know how I would begin to get this off the ground
and if anyone can help me out I would be extremely grateful. Please bear in
mind my knowledge of coding in Access is very limited.

Thank you very much!

Den.
 
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
Calc days between two dates and exclude leap year days scoz Microsoft Excel Worksheet Functions 5 23rd Nov 2007 03:58 PM
Exclude query not working with BE SQL table =?Utf-8?B?VHJhdXRvbg==?= Microsoft Access Queries 17 6th May 2007 08:16 AM
EXCLUDE WEEKEND DATES*** SHIP DATE - TOTAL DAYS = START DATE =?Utf-8?B?S3Jpc3RhbHRpcHM=?= Microsoft Access 4 22nd Mar 2007 01:58 PM
Working with dates and days of the week in a query. =?Utf-8?B?TXJsZW9qZWxp?= Microsoft Access Queries 5 23rd Mar 2005 07:22 AM
Query that asks for dates x number of days away from today's date / comparing two fields in a query Mike H Microsoft Access Queries 2 22nd Dec 2003 08:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:11 PM.