Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Unanswered: help on viewing "current week" employee schedules

    I would like to make a report that displays only the current week's employee schedule. I would like to know how to set this up in a query. Any help is appreciated
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Re: help on viewing "current week" employee schedules

    Originally posted by okiiyama
    I would like to make a report that displays only the current week's employee schedule. I would like to know how to set this up in a query. Any help is appreciated
    http://dbforums.com/t638722.html covered this for current month - current week is similar but you are going to need to define the day your week starts.

    izy

  3. #3
    Join Date
    Jan 2003
    Posts
    35

    Question

    By defining a weekStart, will this need to be a parameter query? I was thinkng that the coding would take care of that for me. The example you gave me is helpful, but Im still a little new to SQL.
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

  4. #4
    Join Date
    Jan 2003
    Posts
    35
    I think I might actually have it.
    Here is the coding.

    In a query field that isn't shown:
    Field: DatePart("w",[Emp_Clock]![Date])
    Criteria: DatePart("w",Now())

    Does that look right?

    Thanks for getting me started.
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

  5. #5
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    you're almost there.


    criteria for [Emp_Clock]![Date]

    DatePart("ww", [Emp_Clock]![Date], firstDayOfWeek) = DatePart("ww", now(), firstDayOfWeek)


    firstDayOfWeek= 1(sunday), 2(monday), 3.....7
    default is sunday


    "w" would get you the same day, "ww" gets the same week.


    izy
    Last edited by izyrider; 01-06-03 at 15:55.

  6. #6
    Join Date
    Jan 2003
    Posts
    35

    Thumbs up

    thanks for the help everything is looking good.
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

Posting Permissions

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