Viewing post 1 (of 1 total)
Thank You, works great
quote:(Select COUNT(DISTINCT dbo.tblHotelReservations.HotelReservationID)WHERE dbo.tblHotelReservations.DateCancelled IS NULL)AS HotelResCount
quote:
WHERE dbo.tblHotelReservations.DateCancelled IS NULL)
AS HotelResCount
April 9, 2002 at 9:15 am
#426868