Results 1 to 4 of 4

Thread: weekly and monthly

Threaded View

  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
« 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