Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unanswered: Working Days Query....... where to start !

    Hi folks

    Im using access 2003 and 2 date fields.

    I am try to do a query the will query some stuff just on working days i.e. Monday to Friday.

    Can anyone point me in the right direct pls.

    Thanks in advance

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    Assuming you have a Date field in the records/table being queried you could include a calculated field such using the Weekday function ie.

    Weekday([DateField]) as DayNum

    in the query, and the filter on this

    WHERE WeekNo Between 3 AND 7.

    or perhaps use this directly

    WHERE Weekday([DateField]) Between 3 AND 7.


    Assuming the optional argument FistDayOfWeek in the Weekday function is set to vbSunday or omitted.

    Would that do it ?

    HTH

    MTB

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Hi
    consider using weekday() in your sql query
    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •