Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    25

    Unanswered: generating weekly reports

    HI!

    I previously posted a question and i got some repllies but i am reframing the question so that i will get some more methods, my problem is i have a list box which has days in it(1,2,3,.....30) and another list box which has months in it(1,2,....12) , now if i want to know how many vistors came on a particular day i select the month and the day from the respective list box and the report is generated, now i want a report generated not on daily basis but a weekly basis( i.e day 1 to day7 ) in a particular month i s there any way to do it please let me know.
    thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    Are you trying to show all of the weeks in a given month or just a particular week?
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

  3. #3
    Join Date
    Mar 2004
    Posts
    25
    I am Trying to show all the weeks , could you help.
    thanks

  4. #4
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    Use your form to pass parameters to a query that will pull all the data you want to show in your report.

    Make sure you group your reords by your data field. Under the "Sorting and Grouping" option for your report - in the "Group On" option choose Week.

    Sample database is an Access 2000 version, let me know if you need an Access 97 version.

    Hope this helps.
    Attached Files Attached Files
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

  5. #5
    Join Date
    Mar 2004
    Posts
    25
    Hi,

    thanks for your help i guess this should help me a lot.I appreciate your help.
    regards
    somanchi

Posting Permissions

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