Results 1 to 5 of 5

Thread: Date part

  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a report that shows the liters per quarter for all the years and it works fine.I want however to have a report showing the liters per month and not per quarter for all the years.Also, i need to arrange the months in the ususal sequence January february March etc with summing up for each year.I have difficutlites in doing that with changing the date part.Can you help me? I am encloising an example as an attachment
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You haven't attached a file yet. To do so, you need to do three things:

    1. Click Browse... and select the file.
    2. Click Upload file.
    3. Click Add to post.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry.Please do aplogize me. Hereis the attachement
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Open rptSummaryPerMonths in design view.

    Activate the Sorting and Grouping window.
    You have added the invoicedate field twice, the first one groups by year and the second one by quarter. You must set the latter to group by month instead of by quarter.

    The group header contains a label with caption Quarter. You must change this to Month.

    The group footer contains a text box with control source =DatePart("q",[invoicedate]). Change the control source to invoicedate (without an = before it) and set the Format property to mmmm. This will make the text box display the full name of the month.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you for your reply ! It works just fine ! Thank you !

Posting Permissions

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