Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    33

    Unanswered: problems creating a report which has a row for each day of the month

    I need to present a monthly report which has data for each approved day within a month. What I have to work with is the client's data which is connected to a date field always being the first day of a month and year, and a field with a set number of days within each month [approved days of service]. How do I create a report which creates a row for each day of the month up until the number within the field [approved days of service]? I would need the report to show the date contiguously from day 1 up to the number in [approved days of service]. Any suggestions would be greatly appreciated!

  2. #2
    Join Date
    Apr 2010
    Posts
    33
    can anyone help get me started with this?

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,476
    Provided Answers: 11
    I would create a temp table that has all days in it for that month then join your data to that table and show all records in the temp table.
    Its a outer join I think or a left join (I don't know the name of the join just how it )

    One join will only show the current data
    The other join will show what u want.
    By the you have to join then by the day number.

    Hope this make cents
    Last edited by myle; 05-17-12 at 19:43. Reason: Spelling
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

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