Post reply

Help! Grouping Last 3 Months Query.

  • January 14, 2009 at 4:01 pm

    #71848

    Hi, I need some query help...

    I have data look similar to this in our customer sales database:

    Date Customer_ID

    -----------------------------------

    1/1/2008 A1111

    1/3/2008 A2535

    12/12/2007 A2554

    12/10/2007 A1255

    I am trying to build a report for '# of Customers for Last 3 month'. Currently I am using 'between (date) and (date)' sql line and put this into excel month-by-month.

    I want sql to show something like this:

    Month # of Customer

    ------------------------------

    01/2008 12

    02/2008 26

    03/2008 12

    Date range for Month of 01/2008 would be 11/01/2007 and 1/31/2008.

    Any help would be greatly appricated!

    Thank you sirs!

  • January 14, 2009 at 4:12 pm

    #926999

    To better help you, please read the first article linked in my signature block. It shows you how to create better posts to help you get better and tested answers to you question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply