I have a table in a database which holds 2 dates, a start date and an end date for a hotel booking.<BR><BR>e.g. we have 3 entries<BR><BR>so if the dates already booked are,<BR><BR> 12 July 99 - 14 July 99 <BR> 15 July 99 - 16 July 99 <BR> 15 July 99 - 18 July 99<BR><BR>now say for instance I want to calculate the day that has the highest<BR>number of bookings between the 14th and 17th of July.<BR><BR>The answer would be the 15th of July with 2 bookings?<BR><BR>Is there an easy way to work this out with an SQL query and with or without some additional vbscript?<BR><BR>Thanks<BR><BR>David