Results 1 to 4 of 4

Thread: weekly and monthly

  1. Mar 10th, 2003, 12:56 AM #1
    -=SC@RF@C3=-
    -=SC@RF@C3=- is offline

    Thread Starter
    Addicted Member -=SC@RF@C3=-'s Avatar
    Join Date
    Apr 2002
    Location
    Somewhere in the middle
    Posts
    158

    weekly and monthly

    Q. pls...

    How can i make a weekly report? (the data must be shown in grid)

    ex. i have a table with inputs dating 1/1/03 to 3/31/03

    i wanted an output from the table on a weekly basis

    the starting day of the week is monday to sunday

    can i have some codes... thanks in advance


    output: in grid

    week1(monday to sunday)
    1/3/03(:note 1/3/03 is wednesday ) - 1/5/03
    TOTAL # of calls
    96

    week2(monday to sunday)
    1/6/03 - 1/12/03
    TOTAL # of calls
    96

    week3(monday to sunday)
    1/13/03 - 1/19/03
    TOTAL # of calls
    79

    week4(monday to sunday)
    1/20/03 - 1/26/03
    TOTAL # of calls
    79

    week5(monday to driday)
    1/27/03 - 1/31/03
    TOTAL # of calls
    73

    february *week1 starts again*
    week1(saturday to sunday)
    2/1/03 - 2/2/03
    TOTAL # of calls
    74
    Last edited by -=SC@RF@C3=-; Mar 10th, 2003 at 01:00 AM.
    Reply With Quote Reply With Quote
  2. Mar 10th, 2003, 10:07 PM #2
    -=SC@RF@C3=-
    -=SC@RF@C3=- is offline

    Thread Starter
    Addicted Member -=SC@RF@C3=-'s Avatar
    Join Date
    Apr 2002
    Location
    Somewhere in the middle
    Posts
    158
    *bumps thread*
    Reply With Quote Reply With Quote
  3. Mar 12th, 2003, 07:01 AM #3
    JordanChris
    JordanChris is offline
    Frenzied Member
    Join Date
    Jan 2001
    Location
    Newbury, UK
    Posts
    1,878
    You can get the day of the week (weekday).
    You can subtract that number from the current date to get Monday / Sunday.
    You can add 7 days to the date (Format date +7D).

    Try it and see.....
    Reply With Quote Reply With Quote
  4. Mar 12th, 2003, 07:46 AM #4
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    You can use dateadd and datediff to play with them dates.

    Check them out
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width