Results 1 to 4 of 4
  1. #1
    Join Date
    May 2014
    Posts
    3

    Unanswered: query to return monthly total with different cut-off dates

    I have uploaded a raw dbase with Date and Total Sales. I need a monthly cut off total but not 1st-30th of every month, but every 6th to 5th of the following month. Please help thanks.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Best way to handle this in my books is to have a table that defines your reporting period. Join the table to be summarised into, to this period table and away y'go
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2014
    Posts
    3
    I only have one table... to where will i join it?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Create a table with period data in. Normally Id suggest
    financialyear
    period
    periodend

    then join to that table to get the financial year and period, and group on that
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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