Results 1 to 2 of 2

Thread: Count Query

  1. #1
    Join Date
    Apr 2002

    Unanswered: Count Query

    I am really having problem with the Count query.

    I have a table called school_holiday withe the fields School_Id, Holiday_Date.

    Now i want to find out how many school holiday did a particular school had in a specific date rage.

    I have tried many ways but it dont seem to work, gives me the wrong result.

    Please can u help me out.

    Thanks a lot


    This does not work :

    SELECT School_Holiday.School_Id, (Select count(School_Id) From School_Holiday Where School_Id=1 and Holiday_Date between #01/06/03# and #31/06/03#) AS TotalHoliday
    FROM School_Holiday
    GROUP BY School_Holiday.School_Id;

    It gives me the right result for the range 1/06/03 to 31/06/03 but if i change the date range it gives me the same output as before.

  2. #2
    Join Date
    Apr 2002
    Never mind, got it working.

Posting Permissions

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