Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Group By Help

    Thank You, works great

    quote:


    (Select COUNT(DISTINCT dbo.tblHotelReservations.HotelReservationID)

    WHERE dbo.tblHotelReservations.DateCancelled IS NULL)

    AS HotelResCount


Viewing post 1 (of 1 total)