Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    Unanswered: grouped by month

    Dear All,

    I'd like to write a query that lists items from a single table but groups the listed items by a date (data of item entered into the table)

    So all items matching a criteria and were entered during March should be listed underneath one-another
    Then all items matching the same criteria but entered during April should be grouped again.

    Not sure what would be the right approach here.

    I'm thinkning, creating a temp table putting data in there but altering the data enterd field into just year and month, and then group the result by that field?

    Will this work?

  2. #2
    Join Date
    Jan 2005
    Green Bay
    group by month(Date)

    More over
    group by year(date), month(date)

Posting Permissions

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