Results 1 to 3 of 3

Thread: Query Help

  1. #1
    Join Date
    Sep 2008
    Posts
    101

    Unanswered: Query Help

    Previously i had help with some of my queries on my system im designing but i need one more thing...
    im trying to create a query where it as for a specific date (i know how to do this) between and to ad then brings back each date between those dates a record has that date on.
    i.e
    if i have 6 records with a date on them for the 6/10/08 and 3 for the 7th and 0 for the 8
    then in my query it should show the result
    Date Total
    6/10/08 6
    7/10/08 3
    8/10/08 0

    and if possible then have a total named the week number which automatically updates and the um of the total for that week at the bottom
    thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Code:
    SELECT [Date]
         , COUNT(*) AS Total
      FROM daTable
    GROUP
        BY [Date]
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2008
    Posts
    101
    Cheers r937 worked perfect

Posting Permissions

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